package com.navi.loaddata.loadService.impl.Dcdata.cell2;

import com.navi.loaddata.core.mesEntity.SpcDcResultData;
import com.navi.loaddata.core.mesEntity.SpcDcdata;
import com.navi.loaddata.core.mesEntity.SpcDcmeasuredataresult;
import com.navi.loaddata.core.mesEntity.SpcDcprocessdataresult;
import com.navi.loaddata.core.mysqlEntity.EtlConfD;
import com.navi.loaddata.core.mysqlEntity.EtlConfDModel;
import com.navi.loaddata.core.repository.impl.MesRepositoryImpl;
import com.navi.loaddata.core.util.ProcessUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.StringUtils;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.List;

@Service
@Transactional(transactionManager = "mesPlatformTransactionManager")
public class LoadDcInfoServiceCELL22 {

    @Autowired
    private MesRepositoryImpl mesdao;

    public List<SpcDcdata> loadDcDataList(EtlConfDModel etlConfD, String dctype) {
        SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
        StringBuffer hql = new StringBuffer();
        hql.append("FROM SpcDcdata WHERE  PRODUCTSPECNAME IS not null and processoperationname>='L4600' and TIMEKEY >='")
                .append(sdf.format(etlConfD.getRunStartTimestamp()))
                .append("' and TIMEKEY < '")
                .append(sdf.format(etlConfD.getRunEndTimestamp()))
                .append("' and subfactoryname = '").append(etlConfD.getShop()).append("' ")
                .append(" and processoperationname not like 'DUM%' AND nvl(SUBSTR(PROCESSOPERATIONNAME, 6,7),'X') <> 'D'");
        if (!StringUtils.isEmpty(etlConfD.getOpe())) {
            hql.append(" and processoperationname = '").append(etlConfD.getOpe()).append("' ");
        }
        hql.append(" and dctype IN(").append(dctype).append(")");
        String hql1=hql.toString()+" and materialname in('A184W026AP08','A1857018BX08','A185M00MAR06','A184W026AP02','A185U00MAT01','A185L009BC05','A185T026CD06','A185P00TBH07','A185U00MAT06','A185T026CD07','A185T026CD05','A185T026CD01','A1854039BS07','A1853003AQ03','A185T026BB06','A1854039BS04','A185U00LAT07','A185W00MBV02','A185W016CA01','A185402TBN02','A185W00GAH01','A184M01PBL04','A185Q00WBD01','A184M01PBL06','A184U00UBJ08','A185A00RBL06','A185U022AJ06','A184U00UBJ03','A185A00RBL04','A185A00RBL07','A185A00RBB06','A185A00RBB05','A185R00VBX06','A185W00FBL02','A185R00VBX04','A185U022AJ03','A185501CBH06','A185V031BW02','A185T021BB07','A185800FBL07','A185501CBH03','A185B00EBD07','A185W00NAK01','A185502NAH02','A185W00MCC08','A1853015CA06','A185W00MCC01','A185900JBH08','A185900JBH02','A184V018AK05','A185U011BT05','A185N004AQ04','A185U011BT01','A185V018AR08','A185W00PCA04','A185800HAN02','A185U024AD01','A185V031CA05','A185V026CB02','A185V031CA01','A185Q00NBR07','A1853003BC06','A185V015BH01','A185V015BH06','A185500WCG06','A185Q00NBR04','A185V02BCF05','A184L01FCC08','A185W012AC03','A185601XBB07','A185601XBB03','A185400SBT02','A185400SBT04','A185W00HAH05','A184V01ACG05','A185V015BV04','A185800PBA05','A185601RBN08','A185800PBA08','A185X00XCH04','A185800PBA04','A185X00XCH02','A185N008AN04','A185K00CCF08','A184V02FCK07','A185L00ABK07','A185700LAB08','A185700LAB02','A185800KBB02','A185L00FCA04','A185L00BBG08','A1853027CK01','A1853027CK03','A185701EAM03','A185L007AU01','A185700XAA07','A185K00XAL07','A185K00CCG04','A185H02BBD05','A185500UBK08','A185500UBK06','A185700WAK01','A185700WAK07','A185S010BW07','A185T024BN02','A185S010BW02','A185K00CBT06','A184V015AG05','A185501EAF07','A185R01BAV03','A185T024BA07','A185501EAF04','A185L00MBF08','A185500QBG04','A185701EAY08','A185800XAD03','A185502ABT08','A185500UCJ05','A185F00KBB04','A185R016AE06','A185400PBA01','A185402TAB03','A1856011BV08','A185402TAB04','A185402TAB02','A1856011BV04','A185S00YBU05','A184J00QBG07','A1853026BT03','A185601GAR04','A185402TAM08','A185402TAM01','A185L00BCH06','A185L00BCH08','A1856003CC03','A185K003AD08','A185500SBX08','A185F00GBF07','A1856003CC07','A185500SBX06','A185D00CAB08','A185400NBX08','A1853009BT04','A185701CCD02','A185403EAP03','A1857012AJ01','A185700YAS01','A185700YAS02','A185C00RCH05','A185C00RCH02','A185C00RCH04','A185700YAS04','A185K003AL06','A185R010BD05','A1852023CK08','A1855024BU03','A185200FCJ02','A185G010CK03','A1853003CJ04','A185G010CK04','A185S012AG08','A185S012AG03','A185S00VBH08','A185S00VBH02','A1853003BA05','A185K00VAT07','A185W014AJ04','A185V032BS04','A185M00BBR01','A185502AAL02','A185N00GAF02','A185M00BBR04','A185Q00MBG07','A184T01QCJ06','A185Q00MBG06','A1853015AU03','A185R012CA04','A1852023BY04','A1852023CA04','A185J00QAN05','A1853003BB03','A185L00RAB05','A185Q00QAU06','A185U015BM04','A185U015BU05','A185701CAB04','A185402UBD06','A1853002AX02','A1853008AA06','A185701CAB01','A185701CAB06','A185400NBR02','A185500UCK01','A1854033BL01','A184V02VBX01','A185402TCC08','A185403CBM03','A1853003CB03','A185601NAU06','A1856003BT07','A1856003BT08','A185N00LBS01','A185800FAA02','A185N00LBS08','A185N00LBS02','A185200HBX01','A185N009AQ02','A185M00MAQ03','A1853024BT02','A185Q00DBC04','A185T029AT04','A185V018BB07','A185V018BB05','A185M007AM04','A185M007AM03','A185F00BBV06','A185M007AM02','A185N00GAY03','A185V017CD03','A185800HBG03','A185N00GAY04','A185700YAV03','A185502JBH07','A185502JBH08','A185N00JAM07','A185900WBJ07','A185U00XAH05','A185U00XAH08','A185800FCH07','A185900WBJ02','A185W013BD07','A185T023AK01','A185800FCH04','A185W00GBD06','A185500XBC01','A185700NAT04','A185700NAT06','A185502FBT08','A185701BAY01','A185T02BCJ07','A185M00CBM01','A185U00YBS06','A185U00YBS01','A1856005BF05','A185T02BCJ03','A185U00YBS04','A185T021AT03','A184V029CB07','A184V029CB08','A185N00MBL01','A185T026BJ05','A185400NCF07','A185C01QBW03','A185W013BL05','A185P01HAQ04','A185W013BS05','A185K00XAB07','A185K00XAB05','A185L00KAG05','A185P01HAQ02','A185200FBQ05','A185900XAX06','A185T02BAT02','A185601XAH08','A185701EBW07','A1853001CG06','A185601XAH02','A185700EBL02','A185701EBW08','A185701EBW06','A185800XAM06','A185L00RAB01','A1853024AT01','A185L00ABM05','A185800XAM03','A1853024AT02','A185800NAH06','A185M00KAP03','A185W00FCE03','A185W00FCG07','A185M00KBD06','A185W00FCG02','A185M00KBD04','A184V02WAG01','A1854039AB07','A185502LAU04','A185U00MAF08','A185H027AD07','A185701AAX01','A184M01SBB06','A1853002AF06','A185501EAB06','A185701AAX06','A184M01SBB01','A185J00KAR04','A185M005AX08','A185J00KAR01','A185300AAN01','A184T01YBM04','A185M00KAA05','A185J00MBB05','A185N00GAP05','A184N01BBH03','A185400SAK04','A184M01PCC04','A184M01PCH04','A185W015BT07','A1853003CH04','A184M01PBS07','A1857010BP08','A1857011BK05','A1857011BK07','A185300AAX08','A185300AAX06','A185502LAR06','A185800NAH01','A183M00RBE03','A185M009BU03','A185800WAX08','A185900WBU01','A183M00RBE02','A185W00FCG01','A185900WBU02','A185M004AT03','A185W00FCD07','A185M004AT04','A185800HBM05','A185W00GAW07','A185W00FCD03','A1857016AV02','A1857016AV04','A185M004AR01','A185M00KAR07','A1853005AK06','A185M00KAR01','A185M00KAR03','A185M00KAR02','A185U023BJ01','A1854033AS04','A185N00MBD07','A185700NAM05','A185N00MBD01','A185502ABS04','A1854033AS07','A185S014CC01','A184N01EAV06','A184T02EAT06','A185L00DCJ05','A185L00DCJ03','A1853017BT05','A185M00CCA07','A185500SBG06','A185502LAN03','A185202VCJ03','A185502LAN07','A185800UBK07','A185K00GBH05','A185E00QBJ06','A185800UBK03','A185400VAW06','A185V01AAX04','A185400VAW07','A185V01AAX05','A185800PBC05','A185N00MBP03','A185N00MAW01','A185U023BJ03','A185H00SBY05','A185N00MAW04','A185N00MAW06','A185S015BA06','A185L00LBV06','A1856019CB07','A1854039AY02','A1856019CB01','A1857015BY05','A185400LAM05','A185V00MAN02','A185M00ACC01','A185M00ACC06','A185501EAM02','A185502KBV08','A185400LAM02','A185L00DBB05','A185601XCJ03','A185601XCJ01','A185700GAX02','A1854033AQ06','A185700GAX05','A185601XCJ06','A185800HBT05','A1854033AQ02','A1857010BD07','A185K00GAR01','A185701EBQ04','A185N00DBY05','A185E00QBJ05','A185N00DBY01','A1857010BD08','A185M008AT05','A185S015BA01','A1856005AR08','A1856005AR02','A185M004AB05','A1856005AR06','A185F00FCB03','A185F00FCB01','A185J00NCE06','A1854010AX04','A1854033AL08','A185K00SAA05','A185J00KAR07','A185K00SAA01','A185501EAM01','A1855021AT06','A185K00BAM03','A185M00ABY03','A185403EBU01','A1855022AY02','A1853001BA02','A1855022AY04','A185J00HCE04','A185K00PAY03','A1855022BH06','A185K003BH06','A185900LBJ07','A1853014AD02','A185900LBJ01','A185900LBJ02','A185701CAX04','A185701EAB04','A185701CAX05','A185701BAS06','A1856005BC05','A1856005BC04','A185G004AG01','A185V018BQ03','A185601GAN03','A185T025BW03','A185V02CBU08','A185T025BW02','A185L00AAQ05','A1854039AB05','A185R012CA07','A184V018AR05','A184V00DBC02','A184V018AR03','A185700VBC07','A185J00TBU07','A185502LAW01','A185U015AV05','A185W00PCH06','A185800PBK06','A184W00JAT02','A184W00JAT06','A184W00JAT04','A184W00JAT05','A185T009CD06','A185700GBM07','A185502NCE02','A185600SBR08','A1854039CA08','A185600SBR02','A185700GBM08','A185403CAC08','A185M00DCJ06','A185W00MAB03','A185T02CCC08','A185W00MAB06','A185402TBA05','A185402TBA08','A185Q00PAU03','A184V02FBE04','A185G01GCE03','A185M005BF06','A184M01PAF08','A185K00UBN03','A185200FBX04','A185800NAK05','A1853015BE04','A185L00NBG05','A185700HAU05','A1853015BE02','A185L00NBG06','A185700YAD08','A185700YAD06','A185800UAV07','A185V02BAN04','A185C00RCB07','A185C00RCB08','A185V01BCD06','A185C00RCB03','A185W00KAM06','A1853001BE05','A185501EBP04','A1853001BE02','A1853001BQ01','A185900WAT02','A185403CAP07','A184T02JBP04','A185402UAG05','A1853001BQ02','A185402UAG04','A185403CAP03','A185L00DBF03','A185402UAG02','A185L00DBF02','A185L00DBF04','A1854029CJ03','A185500UBV07','A185M009CG03','A185C013CA06','A184M01PBT03','A185C01KBQ04','A184V013CD04','A184V013CD02','A185L00ABT04','A185400WAN08','A1852023CC04','A185T021AL06','A185V016AL02','A185G003AA07','A185W00MAG07','A185C013CG07','A185G003AA03','A185T027BQ04','A185800WAN01','A185601XCD06','A185601XCD02','A185601HAD03','A185601XCD03','A185S017AK04','A185300AAY01','A185S010BT06','A185300AAY04','A185502MBG04','A185300AAY05','A185T021AN06','A185502LAS06','A185300AAY02','A185502MBG02','A184T02CBY07','A185501EAL01','A184V019CB08','A185501ECJ04','A185T027AR06','A185501ECJ02','A185T02CCB03','A185U012BM01','A185U012BM02','A185K00XAF04','A185V00MBM05','A185500WAK05','A185N005AR05','A185T009BG02','A185W005CB03','A185500WAK06','A185U00MAU02','A184T01LAM05','A185U022AT01','A184T01LAM01','A1854039AJ08','A185601CCB04','A185S018CF03','A185F006AM08','A185P01EBA05','A185800HCG01','A185F006AR07','A185200FCD04','A185N00KBG01','A185F006AR05','A185800HCG02','A185200FCD08','A185V032BT06','A185701FAH06','A185900WAU03','A185601CCG01','A185900WAU01','A185G003AC05','A185900WAU02','A185G00KAY04','A185G003AC04','A185K00SBA03','A185400MCB03','A185K00SBA01','A185L00ABA07','A1852038BE07','A185Q00DBC03','A185402UBR03','A185L00ABA02','A185700AAJ03','A185700AAJ07','A185V02AAF03','A185J00NAY08','A185800LCG03','A185M00MAQ05','A185G00QAB08','A185502JAC02','A185D00LAU07','A185D00LAU02','A184N01BBA03','A184N01BBA05','A185N006CC03','A185600SBS07','A185M005AA05','A185M005AA04','A185600SBS01','A185V019AW03','A1853017AG04','A185W00HAP01','A185P01HAT06','A185200FBD06','A185P01HAT02','A185P01DBR02','A185W00HCC06','A185Q00PCB06','A185601GAC03','A185601CCG06','A185K00SBR06','A185V02BAX01','A185K00SBR04','A184V00XBP01','A185K004AE04','A185K00XBE07','A184T01PAR01','A185W00KCK01','A185K00XBE03','A1857018CH01','A185H00LCK04','A1857018CJ07','A185T029CK03','A185401WBS03','A185H00MBC01','A1854010BP07','A185P01EBA04','A185403CAX02','A185500SBY07','A185R019AH07','A185M00HAA01','A185700YBA08','A1851013BB03','A185C013CD03','A1856010AA05','A185C00QAE07','A185C00QAE05','A185C00QAE03','A185V01BBD04','A1856010AA02','A185V015AB07','A185700YBA03','A185R019AH02','A185403CAK04','A185700YBA02','A185800NBG03','A185400UAK03','A185400UAK08','A185400UAK01','A185R018AD07','A185R018AD08','A1855010CJ07','A1855010CJ06','A184H01GAD08','A1855010CJ01','A1856010AH07','A1854039CA07','A185200FBP08','A185200FBP07','A1854039AC07','A185200FBP01','A185200FBP02','A185V017AY06','A185501CCH03','A185502KAF07','A1856010BE07','A1856010BE03','A1856010BE02','A185J00TBG02','A1857019AT07','A185U015AU08','A185U015AU01','A185800UBH03','A185T021AP08','A1857019AT08','A1853003BU05','A185502FBT05','A184T01NAV05','A185S00XCG01','A184T01NAV02','A185S01CAD01','A185V018BA03','A185V018BA06','A185W014AJ07','A185502BBT03','A185V015AB06','A185V015AB08','A1854033CE03','A185200KBL01','A185200KBL06','A185S012BP05','A185S012BP06','A185S012BP04','A185S017CF06','A185500SAT01','A185S017CF01','A185M00KAE06','A1854034BJ01','A184W00JAS04','A1857018CH04','A1857019CK08','A1853005AF08','A1853005AF01','A185401WBE02','A185200GAX01','A185900JBN01','A185K00XBE06','A185W014AC07','A185R019BS01','A185900VBN01','A185W004BD01','A185K00XBG05','A185R016AY01','A185W005CK07','A185W004BA02','A185A00RBY06','A185V02ABR01','A185U011AS07','A185C013BY03','A185403CBU01','A185K00HCF04','A185C00RCG05','A185C013BY04','A185600SAA04','A185400PCA07','A185403CCE06','A185U011AS01','A184500VAL05','A185U011AS02','A184500VAL08','A184500VAL06','A185M00GBX04','A185D00CCA02','A185D00CCA01','A185W00QAD08','A185K00SCJ04','A1857018AT04','A1857018AT06','A185700HAA05','A184T01LBP05','A184G00XBM06','A184T01LBP07','A1857019AT06','A185P00TAG05','A185S01AAR04','A185T029CH01','A185W013BX03','A185W013BX04','A185800MAF04','A185401WBQ01','A185800MAF02','A185G004CA01','A185W00FCK07','A1855010BF06','A185700LAF07','A185800MAN01','A1852027AR04','A185800SBR07','A185400NAN01','A1852027AR01','A185800SBR06','A185W00JAX04','A185400NAN07','A185800SBF08','A185800SBR01','A185W00JAX07','A185201TAS06','A185H00MCH04','A185L00FBF07','A185501EAQ02','A185500SAN07','A185700NBE08','A185700NBE01','A185L00FBF04','A184T02BAV01','A1852025AD06','A1856004AV07','A185500SAN03','A1852007AA06','A185V02BAB02','A185T02FBW07','A185T026CE06','A184M01PBW07','A185501CCF01','A185T02FBW01','A185200BAE01','A184M01PBW03','A1856003BU06','A185V02CAY07','A184M01PBW01','A1856003BU02','A184H01GAH02','A185501CCF02','A185D008BX08','A185300BAC02','A185601HBK04','A185300BAC03','A185D008BX03','A185V02CBL05','A185S01CAU04','A185V02CBL03','A185W00KBM02','A1856010AL07','A1856010AL08','A185A00LBK03','A185C01QCD02','A185500SAQ07','A185K00ABX03','A1853001BE07','A185N00JCK04','A185K00TAL06','A185502KBM01','A185S01AAQ02','A185501EBD05','A185S01AAQ06','A185S01CAC04','A185S01CAC01','A184G00XCD07','A184G00XCD06','A185N00AAA03','A1856003BU04','A185V02CAY06','A184M01PAN06','A185V02CAY02','A1855010BF02','A185S017BV03','A184M01PAN02','A185W00GBT06','A185W00GBT05','A185700HCH08','A185W012AS08','A185W012AS01','A1856028AA08','A184V02FAR05','A184V02FAR06','A185700HAU07','A185W017BA08','A185500WAD01','A185T02BBJ02','A185700GCC02','A185V033CE06','A185V033CE03','A185M008AH05','A185Q00LAR04','A185N007AU01','A185800SAG04','A185400NCD07','A185400NCD03','A1857019AD05','A185402TCE02','A1857019AD02','A185403JBK02','A185701AAV01','A185P00LBE07','A185P00LBE04','A185L00BAT07','A185300ABB07','A185300ABB05','A185700GCA05','A185N00MBT08','A185N00MBT03','A185403KAE02','A185N00JBP04','A185K00SAS08','A185701ABJ01','A185S010CH03','A1852023CB06','A185Q00PAU01','A185K003AL04','A1857018BX03','A185M00MAR01','A185U00MAT07','A185M00MAR08','A185U00MAT05','A184W026AP07','A185C013BU07','A185T026CD02','A185U00MAT04','A185400NCJ02','A185H01RBU01','A185H01RBU03','A185H00UAF02','A185Q00LAR07','A185Q00LAR05','A185Q00LAR01','A185200FBS04','A185200FBS01','A1853002AY07','A185U00LAT04','A185W00GAH04','A185402TBN03','A185P01DBW06','A185502FCK02','A185W004AW07','A185W004AW08','A184U00UBJ04','A184U00UBJ05','A184U00UBJ07','A185A00RBL01','A185R00VBX02','A185T021BB06','A185800FBL05','A185V031BW04','A185V031BW01','A185800FBL04','A185B00EBD06','A185B00EBD05','A185502NAH03','A185W00NAK02','A185U011BT07','A1853015CA04','A185900TBP03','A1853015CA01','A185900JBH04','A184V018AK01','A185V02ACJ07','A185W00PCA05','A185V02ACJ04','A185X007BE02','A185W00PCA07','A185V026CB07','A185V018AR06','A185U024AD06','A185V017CH08','A185V018AR02','A185V015BH05','A185Q00NBR05','A185V015BH04','A185V016CE08','A185V016CE07','A185500WCG02','A185V02BCF08','A1854029BP08','A1854029BP03','A185W012AC08','A184L01FCC06','A185T024BD07','A185400SBT01','A185W012AC04','A185W00KBW08','A185W00KBW04','A185200FCE05','A185W012AB03','A185200FCE07','A185601AAT03','A185800SAX08','A185800PBA07','A185800SAX03','A185X00XCH03','A185800PBA02','A185400YBR04','A185K00CCF07','A185700VAG01','A185502MAW08','A185T024BU07','A185502MAW06','A1851026AF05','A1851026AF03','A185L00ABK03','A184V02FCK01','A185N00CCJ03','A185700LAB03','A185800KBB08','A185800KBB07','A185800KBB04','A185701EAM08','A185701EAM05','A185800KBE04','A1853027CK07','A185L007AU08','A1853027CK05','A185L007AU07','A185701EAM07','A185L007AU02','A185700XAA04','A1852027AS02','A184W022AU06','A184W022AU03','A184W022AU07','A185502ACA02','A185700XAA02','A185K00XAL03','A185502ACA01','A185T023AW07','A185800NCD06','A185H02BBD04','A185L00PCK08','A185700WAK08','A185S019BQ01','A185L00FBM07','A1853009CF06')";
        String hql2=hql.toString()+" and materialname in('A1853002AB04','A1853009CF02','A185K00CBT07','A1853009CF07','A185T024BN01','A185L00FBM04','A185K00CBT08','A185900NAW07','A185L00MBF07','A185L00MBF03','A185400NBS08','A185M006AN07','A185701EAY05','A185M006AN03','A185400PBA03','A185400PBA06','A185K00PBA01','A185K00PBA06','A185601XAB02','A185400PBA02','A185M00ABE02','A185L00MAB03','A185S00YBU07','A1853026BT08','A185601GAR08','A185L00MAB01','A185402TAM02','A1853026BT04','A185F00KBB02','A185H00UAF03','A185H00NAW03','A1853005CK07','A185C013BR01','A185H00UAF06','A185H00UAF08','A185500SBX03','A184T02FCD06','A185K003AD01','A185500SBX05','A185D00CAB03','A185D00CAB04','A185403EAP01','A185K002BV03','A185403EAP07','A185K002BV06','A185K002BV01','A185C00RCH03','A1853009BT07','A1857012AJ07','A185M00KAN04','A185K003AL05','A185K003AL03','A185K003AL08','A185200FBQ06','A185L00ACG02','A1853003CJ07','A185T02ACE08','A185200FCJ04','A1853003CJ01','A1853003BA03','A185G010CK01','A1853003CJ03','A185G010CK02','A185200FCJ07','A1853003BA02','A185W013BR08','A185W004AA05','A185W014AJ02','A185V032BS01','A185M00BBR05','A185502AAL08','A185502AAL03','A184T01QCJ04','A184T01TCD08','A184T01TCD04','A184T01TCD01','A185Q00MBG04','A185S01CAK07','A185502ABA03','A1853015AU04','A185502ABA07','A185S01CAK04','A185S016AV08','A185200FBQ02','A185K00VAT08','A185J00QAN07','A1853025AE08','A1853025AE05','A1852023CA07','A1853003BB07','A185400MBC05','A185J00QAN01','A185J00QAN02','A1853025AE07','A1857019BE01','A185U015BU02','A1853008AA02','A185U015BM02','A185400NBR08','A185500UCD08','A185400NBR01','A185500UCK03','A185Q00QAU01','A1853024BK08','A184V02VBX04','A185403CBM05','A184V02VBX03','A1854011BW01','A185402TCC04','A185402TCK02','A185402TCK03','A185403CBM01','A184T020AC07','A184T020AC04','A185P01BCF08','A185N009AQ01','A185P01BCF02','A185N00LBS07','A185400VBG02','A185500YAK04','A185400VBG04','A185400VBG06','A185U00WCC08','A185900JBF05','A185M007AM07','A185T029AT06','A185P01GAV02','A185P01GAV04','A185V017CD01','A185F00BBV04','A185V017CD05','A185502BCK08','A185502BCK05','A185700YAV06','A185P00TBK01','A185502JBH04','A185502BCK03','A1857013CK04','A185M00EAT03','A185800FCH05','A1851014BK07','A185T023AK04','A185P00LBK07','A185500XBC05','A185502AAP03','A185701BAY03','A185L00PAD01','A185P00LBK05','A185700NAT08','A185C013BU04','A185P00LBK08','A185S01CBK07','A185502JAL02','A185P00LBK02','A185800PAG01','A185C00QAL08','A185P00LBK04','A185C00QAL04','A185L00MAV05','A185S00XCG07','A185800PCK04','A185S01CBK04','A185700YAV05','A185T023AK02','A185402TCJ04','A1856005BF08','A185M00CBM05','A185402TCJ06','A1851014BK02','A185402TCJ03','A184V029CB05','A185S019CG06','A185M00EAF08','A185T026BJ08','A185C01QBW08','A185P01HAQ07','A1851013AD08','A185W013BS03','A185W013BS06','A185700LAS02','A185W013AD01','A185K00XAB02','A185900JAY03','A185700EBL03','A185701EBM07','A185U022AF04','A185701EBM02','A185701EBM01','A185S00XAB05','A185M00KAP05','A185L00ACE04','A185800NAH05','A185800NAH03','A185M00KAP01','A185M00KBD03','A185M00KBD05','A184V02WAG06','A184V02WAG02','A185H025BT04','A185601BAX01','A185U00MAF03','A185U00MAF06','A184V02WAG05','A1853002AF05','A1854033BJ01','A1854033BJ06','A184M01SBB03','A185P00LBD01','A185P00LBD05','A185M00KAA07','A184T01YBM05','A185403CAM02','A185300AAN02','A185M00KAA06','A1855022AP04','A185M005AX01','A185P01CAK07','A185J00MBB01','A185N00GAP08','A184N01BBH05','A185Q00PAA08','A185400SAK08','A185Q00PAA03','A185400SAK01','A184N01BBH01','A185400SAK02','A185V031AL03','A184M01PCC08','A1853003CH03','A184M01PCC07','A185200FAW06','A1853001BA01','A183M00RBE07','A185M009BU02','A185800WAX03','A185601HAB07','A185601HAB03','A185900WBU03','A185700YAT05','A185800FCC02','A185M004AT07','A185900TAL03','A185U025CA04','A1857011AW06','A1857016AV08','A1857011AW01','A185M00JCE01','A185M004AR04','A185W00FCD04','A185W00GAW03','A185V02CBK05','A1857011AW07','A1857016AV03','A185U014AT03','A185401WAW07','A185401WAW04','A185U023BJ08','A185401WAW06','A185502ABS02','A1854038BT08','A1856019CD08','A1854033AS02','A185N00MBD02','A185W00KAR08','A185L00DCJ08','A185W00KAR02','A185L00DCJ06','A185T02GBR02','A185L00DCJ04','A1857015BY06','A185400SAY04','A185502LAN08','A185402TBX02','A185502LAN02','A185601JAR03','A184U00UAQ06','A185K00GBC02','A184U00UAQ08','A184T01LBB05','A185K00GBC01','A185K00GBH04','A185K00GBH06','A185M006AM07','A185K00GBH08','A184U00UAQ03','A185K00GBH02','A184U00UAQ01','A185800PBC06','A185403EAC06','A185403EAC01','A185W00GBE01','A184T01VBK06','A185N00MAW03','A185U016AG04','A185W00GBE02','A185L00RAA05','A184T01VBK05','A185L00RAA08','A185R00WCC03','A1854039AY03','A1856019CD02','A1856019CB05','A1856019CB06','A185L00DBB07','A185601XCJ02','A185403EAG02','A1854033AQ08','A185202JAH04','A1854033AQ03','A185400PAY02','A185800HBT04','A185N00DBY03','A185701EBQ01','A185N00DBY08','A185E00QBJ01','A1856005AR04','A1856005AR03','A185M008AT02','A1856005AR07','A185F00FCB04','A1854010AX05','A185K00SAA08','A185403CAM04','A185L00DBB01','A185K00BAM07','A185502KBV03','A185L00DBB02','A185G003BP05','A1853001BA06','A1855021AT02','A185K00BAM04','A185M00ABY02','A1855022AY05','A1855022AY03','A1855022BH05','A185J00HCE01','A185J00HCE08','A185H00LBF03','A1855022BH04','A185K003BH05','A185K00PAY01','A185403EBU02','A1853014AD03','A1853014AD04','A185900NAE08','A185T029CE05','A185T029CE04','A185T029CE01','A185900NAE02','A185900NAE04','A185900LBJ04','A185701EAB06','A185T023AL08','A185T023AL04','A185701CAX03','A185701BAS03','A185701BAS02','A185701BAS05','A1856005BC02','A185701BAS08','A185G004AG02','A185T02FCA08','A185V018BQ07','A185T025BW01','A185900TAN08','A185G01GAD01','A185V02CBU03','A185900TAN03','A185L00AAL03','A185900TAN01','A185900TAN02','A185L00AAQ06','A185L00AAL04','A1854039AB06','A184V00DBC01','A185600SAC06','A184V018AR06','A185700VBC06','A185700VBC02','A185U015AV06','A185700VBC03','A185M008AH02','A185502LAW07','A185W00PCH04','A185M00DCJ07','A185502NCE05','A185502NCE03','A185601RCG01','A185601RCG02','A185403CAC03','A1853002AP07','A185403CAC02','A185J00SCA08','A185V02CAS03','A185800WBB08','A185800WBB02','A185402TBA03','A184V02FBE05','A185V00LBA08','A185V032AF06','A185Q00PBY06','A184L01FCA04','A184L01FCA07','A185G01GCE02','A185G01GCE06','A185M005BF07','A185200FBX08','A1853003CG05','A185K00PBV01','A184M01PAF02','A185200FAU04','A185200FAU08','A185M00ECA05','A185P00TBR03','A185V014AJ06','A185800MAD01','A185700YAD03','A185700YAD07','A185700HAU06','A185V014AJ03','A185W017BA01','A185700YAD01','A185C00QAH06','A185V02BAN03','A185C00QAH01','A185H00MBP03','A185V01BCD07','A185800UAV08','A185V01BCD03','A185900WAT08','A185402UAG08','A185701BCK06','A185403CAP02','A185K00TAG05','A185K00TAG06','A185W00KBF08','A185K00DCC07','A185701BCK01','A185M00MAS03','A184M01PBT01','A185502NBD06','A185C01KBQ03','A184M01PBT06','A185T029CD07','A185400WAN02','A184V013CD01','A185T021AL03','A184V013CD03','A185T021AL04','A185400PAG01','A185400WAN07','A185S017AK03','A185601XCD05','A185601XCD07','A185G00PAE06','A185G00PAE04','A185G00PAE05','A185C013CG08','A185W00MAG04','A185W00MAG01','A1854039AF02','A1854039AF05','A185601HBB06','A185C013CG02','A1854039AF06','A185C013CH02','A185M00EAM07','A185M00MAS04','A185W00KBF05','A185M00EAM06','A185M00EAM08','A1855022CD05','A185S01BAD04','A185S01BAD01','A185403JAN04','A185S010BT05','A185300AAY06','A185502MBG05','A185T021AN08','A185403JAN02','A185501EAL03','A185501EAL04','A184T02CBY04','A185M009BR04','A185501ECJ01','A185U012BM05','A184T01LBQ05','A185K00XAF03','A184T01LBQ08','A185K00XAF08','A185U00MAU08','A185N005AR03','A184V02FAS02','A185U022AT04','A185K00PAL07','A185K00PAL03','A185K00PAL01','A185F006AM03','A185S018CF05','A185601CCB02','A185401WBS08','A185P01EBA03','A185P01EBA06','A185502JAF05','A185800HCG04','A185701FAH02','A185G00KAY07','A185H00MBL07','A185G003AC01','A185G00KAY02','A185502JAC05','A185K00SBA02','A1854039AJ01','A185L00ABA08','A1854039AJ03','A185Q00DBC08','A1852038BE03','A185402UBR04','A185402UBR07','A1854039AP07','A1852038BE04','A1853024BT08','A185700AAJ08','A185502JAC01','A185T009AL04','A185G00QAB06','A185800WAU01','A185D00LAU01','A185W005CG01','A184N01BBA07','A184N01BBA06','A185800WAU08','A185G00SAQ08','A185G00SAQ01','A185N006CC02','A185600SBS06','A185W00HAP04','A1853017AG01','A185W014AA05','A185800HBQ05','A185G00SAQ02','A185V02BAX08','A185K00XBE05','A185H00LCK08','A185H00LCK05','A1857018CH03','A185W00KCK04','A185T02BCG05','A1854014BH04','A185H00LCE08','A185K00JCE01','A1854010BP02','A185H00PBQ04','A185S01ABB01','A185701BAB05','A185M00HAA06','A185R019AH08','A185R019AH05','A185500UCH05','A1851013BB06','A185C013CD06','A1856010AA03','A185C00QAE08','A185X008AE01','A185U014BD08','A185U014BD01','A1854033CE07','A185500UCH06','A185403CAK05','A185500UCH03','A185403CAK06','A185400UAK07','A185U015AX08','A185401WAR05','A185L00JBV02','A185U015AX04','A185500UBQ05','A1856010AH03','A185P01EAS02','A185200FBP04','A1852023CH02','A1853003BU08','A185501CCH06','A185J00TBG05','A185U015AY01','A1857019AS01','A185501CCH04','A185800UBH02','A185T021AP07','A185L00FAQ07','A185U015AU06','A1857019AV02','A185L00FAQ08','A185S01AAR07','A185L00FAQ04','A1857018CG06','A1857018CG04','A1852027AD03','A185S01CAD06','A185H003AK01','A185H003AK08','A185V018BA01','A185200KBL07','A185V015AB01','A185200KBL05','A185200KBL04','A185T02CBC01','A185403EBA08','A185500SAT07','A1857019AX08','A185S017AW05','A185S017AW08','A185403CBU02','A184W00JAS07','A185W00FBE01','A1852023CE07','A1853003CG08','A1857019CK05','A185Q00MAT04','A1857018CJ06','A185200GAX02','A185R019BS03','A185K00XBG07','A185W004BD04','A185W00NAD08','A185502NAF04','A185W00NAD02','A185502NAF06','A185W005CK05','A185502NAF08','A185502NAF03','A185P01BAP06','A185P01BAP01','A185P01BAP04','A185W004BA07','A185W017CJ08','A185W017CJ06','A185G00UBS08','A185W005CK08','A185V02ABR08','A184T01PAA08','A185A00RBY05','A185500SAT08','A185K00HCF06','A185400PCA03','A185400PCA05','A185600SAA03','A185H00NBF04','A184500VAL02','A185D00CCA06','A185D00CCA05','A185W00QAD05','A185K00SCJ03','A185K00SCJ01','A185W00QAD04','A185700HAA08','A185700HAA03','A1857018AT02','A185701FCH01','A185701FCH03','A184G00XBM07','A185S01AAR08','A185T02FAA08','A184T01LBP03','A185S01AAR02','A184H01GAH07','A185401WBQ03','A184T01LBP06','A185400NAN04','A185800SBR03','A185700LBG03','A185400NAN03','A185800SBF06','A185800SBQ08','A185800SBR04','A185800SBQ01','A185201TAS03','A185500SCK01','A1857012AA02','A185501DBS03','A185S017AW02','A185501EAQ03','A185501EAQ01','A185L00FBF05','A185400QAR03','A185L00FBF02','A185K00XAK01','A1852007AA08','A1852007AA05','A185500SAQ08','A185500SAN06','A185C01QCD05','A185502KBM03','A185K00ABX07','A185T026CE01','A185L00CAU03','A1856003BU03','A184M01PBW02','A184H01GAH08','A185S01AAQ07','A185501EBD07','A185G00UBS03','A185D008BX07','A185V02CBL01','A185800MAD08','A185A00LBK08','A185700HAA02','A185C013BS01','A185N00JAQ08','A185501EBP03','A185S01AAQ03','A184G00XCD01','A184G00XCD03','A185S01BCK01','A185R016BE06','A185501EBD02','A185701CAW03','A184M01PAN04','A185701CAW07','A184M01PAN07','A1852023CC06','A185S017BV02','A185W00GBT07','A1856010AL04','A185S00VAV03','A185B00GAV08','A185700HCH03','A185B00GAV05','A185A00LBK02','A185K00ABY01','A1856028AA01','A185K00RBV08','A1856028AA07','A184V02FAR01','A185P00TBR04','A185800MAD03','A185K00SAS02','A185601GAH06','A185601GAH05','A184W027BN01','A185502JCG05','A185T02DBG04','A185502JCG04','A185Q00LAR02','A185V02AAH06','A185V02AAH04','A185P00TBH01','A185800SAG07','A185N009AQ08','A1856003BT01','A185701AAV06','A1857019AD06','A184M01PAF06','A185M00ECA01','A185402TCE07','A185P01GAP08','A185P01GAP04','A185300ABB03','A184T02GCF06','A184T02GCF07','A185N00MBT07','A185400WAA01','A185400WAA05','A184T02GCF05','A185N00MBN05','A185L00BBF02','A185N00MBN08','A185N00MBN03','A185Q00PBY04','A185K00SAS05','A185P01BCD02','A1852023CB08','A185S010CH01','A185900NCD08','A185200FBW08','A1853002AY04','A185200FBW05','A185M00MAR05','A1857018BX06','A184W026AP06','A185M00MAR03','A185J00QAQ02','A185U00MAT03','A1853003AQ04','A185400NCJ01','A185400NCJ03','A185Q00LAR08','A185H01RBU02','A185T026BB05','A185P00TBH04','A185200FBW04','A1853002AY03','A185X007BR03','A185W016CA05','A185U00LAT02','A185J00TBU01','A185W00GAH06','A184M01PBL08','A185502FCK08','A185Q00WBD04','A185A00RBB08','A185W00FBL03','A185W00FBL05','A185A00RBL05','A185R00VBX03','A185A00RBB03','A185T021BB04','A185900UBC03','A185800FBL08','A185900UBC02','A185B00EBD03','A185Q00WAC06','A185B00EBD01','A185Q00WAC01','A185502MBU03','A185502MBU04','A185M005CA08','A185W00NAK03','A185W00NAK08','A185502NAH07','A185W00MCC03','A185900JBH07','A185R015CA05','A185U011BT04','A185V02ACJ08','A185X007BE07','A185X007BE01','A185W00PCA06','A185V018AR04','A185V031CA08','A1853003BC01','A185500WCG07','A185500WCG04','A1853003BC03','A185Q00NBR03','A185Q00NBR01','A185Q00NBR06','A185Q00NBR08','A1856010AM06','A1856010AM03','A185501CBK01','A185501CBK07','A185W00LBJ06','A185W012AC07','A185601XBB08','A185W012AC06','A185400SBT03','A185W00HAH07','A185200FCE08','A185200FCE06','A185W00KBW02','A185700HCF06','A185W00HAH02','A185700HCF01','A185W012AB04','A185200FCE01','A185601AAT02','A185X00XCH07','A185X00XCH05','A185601RBN04','A185800PBA06','A185V015BV02','A185V02CBB03','A185800PBA03','A185800PBA01','A185V02CBB04','A185700VAG04','A185502MAW04','A185T024BU06','A185601RBD05','A185N00CCJ07','A185800KBS05','A185800KBS01','A185N00CCJ02','A185L00FCA03','A185800KBB01','A185D00CBV05','A185R010BG06','A1852027AS06','A185R00XAT07','A185K00CCG07','A1852027AS07','A184W022AU04','A185K00CCG06','A185701EAM04','A1857010BJ05','A185H02BBD07','A185700XAA03','A185T024AV08','A185T023AW02','A185500UBK07','A185K002AX05','A185K002AX01','A185T024AX07','A185H02BBD02','A185K002AX04','A185700WAE02','A185L00PCK06','A185700WAE04','A185L00FBM08','A185L00FBM01','A1853002AB03','A184V015AG07','A185900NAW04','A184V015AG03','A185K00PAM05','A185K00PAM01','A185T024BA08','A185L00MBF05','A185500QBG02','A185500QBG01','A185M006AN08','A185500UCJ03','A185K002AW05','A185502ABT07','A185402TAB08','A185M00ABE07','A185M00ABE05','A1856011BV03','A1856011BV06','A185M00ABE01','A185601XAB06','A1854039BY08','A185L00MAB07','A185601GAR05','A185C013AX05','A1853026BT01','A1853005CK06','A185C013BR03','A1853005CK05','A185C013BR06','A185C013BR02','A1853005CK02','A184T02FCD07','A184T02FCD05','A184T02FCD04','A185H00UAF04','A184T02FCD01','A185400NBX04','A185400NBX03','A185400NBX02','A185400NBX07','A185L00ACH06','A185D00CAB02','A185700YAS08','A185400NBX01','A185L00ACH01','A185L00ACH02','A185700YAS05','A185C00RCH06','A185W00LBT02','A185L00ACG06','A185200FCJ08','A185G010CK05','A1853003BA06','A1853003BA08','A185K00VAT05','A185S012AG02','A185L00FAL05','A185W004AA01','A185502AAL07','A185N00GAF05','A185502AAL06','A185L00AAW05','A184T01QCJ05','A185M00BBR02','A184T01TCD03','A184T01TCD05','A185Q00MBG03','A1853015AU05','A185L00AAW07','A185502ABA02','A185S016AV07','A1852023BY01','A1853025AE06','A185400MBC03','A185W013BR02','A1853025AE02','A185L00RAB07','A1853002AX08','A184T01QBN08','A185402BCK02','A184T01QBN01','A185402TCH05','A185402TCH06','A185402TCH01','A1853024BK04','A185601NAU07','A185K004AJ06','A185601NAU04','A184T020AC02','A185M007AV02','A185800FCD07','A185P01BCF07','A185N009AQ06','A185800FAA03','A185N00LBS04','A185800FCD02','A185500YAK05','A185U00WCC07')";
        String hql3=hql.toString()+" and materialname in('A185P019CH07','A185U00WCC03','A185W00GBD01','A185200HBX04','A185W00GBD03','A185700AAJ02','A185M00MAQ01','A185M00MAQ08','A185M00MAQ02','A185900JBF08','A185M007AM08','A185V018BB03','A185900JBF03','A185V018BB08','A185N00JAM04','A185V018BB06','A185F00BBV03','A185P01GAV01','A185P00TBK05','A185L00EAW06','A1857013CK02','A185M00EAT04','A185900WBJ05','A185W013BD02','A185K00UAQ08','A185L00PAD02','A185U00WCC02','A185701BAY04','A185S01CBK01','A1857018CG07','A185800PCK08','A185502FBT07','A185500WBE03','A185402TCJ05','A185M00CBM02','A185700LAS05','A185700LAS06','A184V029CB06','A185S019CG08','A185T021AT06','A185S019CG02','A185700LAS08','A185400NCF01','A185W013BL07','A185C01QBW07','A185T026BJ06','A185M00EAF04','A185P01HAQ05','A185W013BL06','A185W013BL04','A185W013BS07','A185L00KBR03','A1855024BU08','A185L00KBR01','A185K00XAB03','A1855024BU05','A185K00XAB04','A185200FBQ07','A185L00ACG07','A185W013BS02','A1851013AD02','A185601XAH06','A185700EBL06','A1853001CG04','A185L00RAB06','A1853024AT07','A1853024AT03','A185701EBM06','A185L00RAB02','A185800FBW05','A185L00ACE03','A185S00XAB08','A185L00ACE01','A185W00FCE06','A185W00FCE07','A185W00FCG06','A185W00FCE05','A185W00FCG08','A185W00FCE02','A185800WAX06','A184V02WAG07','A185502LAU02','A185L00EAU03','A184V02WAG03','A185502LAU06','A185H025BT02','A185H025BT03','A185701AAX07','A1853002AF02','A1853002AF01','A185L00EBD07','A185P00LBD02','A185300AAN08','A184T01YBM06','A185300AAN05','A185J00KAR02','A185M00KAA01','A185M005AX03','A185M00KAA03','A1855022AP03','A185403CAM03','A185J00MBB02','A185P01CAK04','A185402UAJ08','A1857010BP01','A184M01PCH08','A1857018CA02','A184M01PCC03','A185W015BT03','A1857011BK06','A185400NCD01','A185300AAX07','A185200FAW08','A185300AAX01','A1857011BK03','A185300AAX05','A1853014AD06','A185502LAR04','A185K00GBC03','A185402TBX06','A185800WAX07','A183M00RBE05','A185800FCC01','A185M00DAE03','A185700YAT03','A185800FCC07','A185900WBU07','A185900TAL05','A185W00FCD02','A185U025CA03','A1857016AV06','A185V02CBK03','A185U014AT04','A185V02CBK02','A185401WAW02','A185V02CBK01','A185M00KAR05','A185H00SBY07','A185U016AG06','A185402UAJ02','A1854033AS08','A185502ABS07','A1855022AP06','A185N00GAP06','A1854033AS03','A185S014CC05','A185W00KAR04','A184N01EAV08','A184T02EAT02','A185400SAY01','A185500SBG04','A184N01EAV02','A185500SBG03','A184T02EAT08','A185V018BK05','A185400SAY05','A1853017BT06','A185V018BK02','A185M00CCA05','A185700EBU06','A185502LAN04','A185700EBU04','A185700EBU03','A185202VCJ01','A185601JAR04','A185800UBK06','A184U00UAQ05','A185601JAR01','A184U00UAQ02','A185M006AM01','A185400VAW05','A185400VAW04','A185403EAC07','A185A00SAR02','A185800UBK02','A185701ABQ03','A185H00SBY01','A184T01VBK08','A184T01VBK01','A185R00WCC08','A185W00GBE04','A184T01VBK02','A185L00RAA04','A185R00WCC01','A185501EAM07','A1854039AY06','A185M00CCA03','A184T01QBL08','A1856019CB03','A185400LAM04','A185M00ACC05','A185V00MAN05','A185N00MBP02','A185403EAG08','A185700GAX04','A185202JAH06','A185202JAH03','A1854033AQ01','A185800HBT06','A185N00DBY07','A1857010BD06','A185L00LBV04','A185M004AB06','A185M008AT03','A185M008AT04','A1852008AA08','A1854033AL02','A185K00SAA07','A185P00LBD07','A1853001BA07','A185502KBV06','A185L00DBB04','A1853001BA03','A1853001BA04','A185M00ABY06','A185J00HCE07','A185H00LBF04','A1855022AY07','A185J00HCE05','A185J00HCE06','A185J00HCE02','A185K00PAY06','A185K00GBC05','A185U016BE05','A185900LBJ05','A185U013BA01','A185701CAX01','A185701CAX02','A185601YCE01','A185701EAB05','A185T029CE03','A185900JAY02','A1856005BC08','A1856005BC03','A185T02FCA03','A185G01GAD06','A185G01GAD04','A185T02FCA07','A185T025BW08','A185L00AAL06','A185601GAN02','A185900TAN04','A185L00EAU06','A185600SAC08','A185S016AV01','A184V018AR07','A184V018AR01','A185M007AW07','A185700VBC08','A185B00GBH02','A185700VBC05','A185700VBC01','A185B00GBH01','A185800PBK08','A184W00JAT08','A185502NCE07','A185T009CD03','A184W00JAT03','A185T009CD04','A1854039AC08','A185800PBK01','A185W00PCH02','A1853002AP03','A185202HAW06','A1853002AP02','A185W00MAB01','A185T02CCC05','A185403CAC07','A185T02CCC01','A185V02CAS04','A185W00MBV07','A185Q00PAU05','A184U00YBA03','A185W00MBV08','A185V00LBA01','A185V00LBA04','A185N00DBY02','A184L01FCA06','A185L00BBS07','A185L00BBS03','A185M005BF08','A185M005BF04','A185K00PBV03','A184M01PAF03','A185K00UBN06','A185K00UBN01','A185K00RBV02','A185W017BA04','A185800NAK08','A185P00TBR01','A185700HAU04','A185800NAK02','A185D00ECD07','A185C00QAH08','A185L00NBG04','A185V02BAN01','A185D00ECD06','A185400WBS01','A185D00ECD08','A185800UAV06','A185V01BCD08','A185501EBP06','A184T02JBP07','A1856003AF08','A185W00KAM01','A184T02JBP05','A1853001BQ07','A184T02JBP06','A1853001BQ03','A185700BAS07','A185700BAS01','A185L00DBF05','A185S019AV01','A185500UBV08','A185601XAN02','A185M009CG01','A185500UBV03','A185K00TAG02','A185701BCK05','A185701BCK03','A185W016BL03','A185502NBD01','A184M01PBT04','A185L00ABT05','A185C01KBQ06','A185L00ABT06','A185502NBD04','A185T021AL05','A185400PAG07','A184M01PBT08','A185S017AK07','A185R00XCC08','A185S017AK08','A185G00PAE08','A185G00PAE03','A185V01BCD04','A185V01BCD02','A185C013CG01','A1854039AF07','A185W00MAG03','A185C013CG04','A185W00MAG02','A185501CCB02','A185501CCB05','A185501EAL08','A185M009BR07','A185M00MAS02','A185403JAN07','A185G00NBA07','A185601XCD01','A185T009AL07','A185502JAT06','A185M009BR03','A185M009BR06','A184T02CBY06','A185C013AV02','A185502JAT01','A185T02CCB02','A185M00EAM02','A184V02FAS08','A185V00MBM08','A185K00XAF02','A185500WAK03','A184V02FAS05','A184V02FAS03','A185W005CB06','A184T01LAM07','A185K00VBS03','A185U022AT08','A185S018CF07','A185S018CF08','A185701EBP07','A185P018CH02','A185P01EBA08','A185401WBS07','A185H00LCE03','A185200FCD03','A185502JAF06','A185V032BT01','A185701FAH07','A185V032BT03','A185S014CB05','A185V032BT08','A185900WAU05','A185F006AR04','A185601CCG05','A185F006AR01','A185L00ABT01','A185400MCB04','A185G00KAY01','A185601CCG04','A185400MCB08','A185601CCG02','A185502JAC08','A185H00MBL03','A185K00SBA04','A1854039AP05','A1854039AP02','A185W005BU07','A185Q00DBC06','A185402UBR02','A185V02AAF08','A185W005BU08','A185W005BU04','A185V02AAF06','A185V02AAF02','A185800LCG02','A185700AAJ06','A185G00SAQ07','A185R017AL03','A185800WAU04','A185600SBS03','A185600SBS08','A185M005AA03','A185W00HAP06','A185600SBS02','A1853017AG05','A185P01HAT05','A185200FBD02','A185W00HCC05','A184N01BBA04','A185V02BAX05','A185W014AA02','A184V00XBP06','A185800HBQ07','A184T01PAR05','A185V02BAX02','A185U00YBY04','A185T02BCG07','A1854014BH02','A1853026BK03','A1853026BK08','A185P01EBA01','A185500SCF08','A1854010BP01','A185701BAB08','A185403CAX07','A185403CAX04','A185S01ABB06','A185700YBA05','A1854039CK05','A1851013BB02','A185C013CD02','A185601NCD06','A1856010AA07','A185601NCD02','A185M009BR02','A1856010AA04','A185601NCD07','A185U014BD02','A185400UAK04','A185700YBA04','A185403CAK02','A185L00JBV03','A185800NBG01','A185U015AX01','A185800NBG02','A184H01GAD03','A184H01GAD06','A184H01GAD04','A184H01GAD02','A1854039AC02','A185200FBP05','A1852023CH07','A185200FBP03','A1853003BU03','A185U015AY04','A185502KAF06','A184V02ECE06','A185501CCH01','A1857019AV08','A185U015AU07','A185800UBH08','A185U015AU03','A185P00QBK05','A1857019AV06','A1857019AV07','A185L00EBD01','A1852027AD07','A1852027AD01','A1857018CG03','A1852027AD04','A184T01NAV06','A185H003AK07','A185V018BA05','A184T01NAV01','A185S00XCG04','A185S01CAD08','A185M00BBR07','A185L00FAL04','A185400NAT04','A185502BBT07','A185502BBT02','A1854033CE08','A185402BBG08','A1854038AR06','A1854034BJ07','A185403EBA06','A185403EBA03','A185S012BP02','A185M00KAE03','A185M00KAE02','A1854034BJ04','A185500SAT05','A185403CBU07','A185W00FBE05','A185500WAQ07','A185500WAQ02','A185T02BCG02','A1857018CH07','A1853005AF02','A185W00KCK06','A185200GAX07','A185900VBN07','A185900JBN08','A185W014AC04','A185900VBN05','A185W004BD08','A185502NAF07','A185W004BD05','A185K00XBE02','A185W004BA06','A185W00NAD07','A185K00XBG04','A185W004BA05','A185W005CK04','A185V02ABR05','A185W00QAD07','A185M00GBX03','A185K00HCF03','A185K00HCF05','A185C013BY01','A185C013BY02','A185600SAA01','A185403CCE02','A185500SCK05','A185400PCA02','A185H00MCH08','A185M00GBX01','A185K00SCJ08','A185W00GAL01','A185W00GAL03','A1857018AT05','A185700HAA04','A185701FCH02','A1857019AT02','A184C017AL07','A184C017AL05','A185T02FAA02','A184T01LBP04','A185W013BX08','A184T01LBP02','A185800MAF06','A185T023BH03','A1855010BF03','A185W00FCK04','A185W00FCK06','A1852027AR08','A185800SBR08','A185700LBG04','A185700LBG06','A185800SBQ05','A185800SBQ06','A185800SBB01','A185S01AAV08','A185S01AAV06','A185501EAQ07','A1857012AA04','A185L00KBB08','A185500SAN08','A184T02BAV07','A185C01QCD07','A185500SAQ04','A185C01QCD01','A1856004AV06','A185700LAF05','A185700LAF04','A185W00FCK02','A185200BAE03','A185T026CE02','A185501CCF07','A185501CCF04','A185601HBK03','A185D008BX06','A185800SBB02','A185201TAS02','A185601HBK08','A185601HBK01','A185601HBK02','A185300BAC01','A185W00KBM04','A185W00GAJ06','A185W00KBM01','A185K00TAL05','A185502KBM02','A185K00TAL01','A185C013BS06','A185N00JCK07','A185K00TAL03','A185W00KAM07','A185501EBP08','A185501EBP07','A185C013BS02','A185S01BCK03','A185V02CAY04','A185R016BE02','A185701CAW05','A185R016BE04','A185B00GAV03','A185W00GBT03','A185700HCH02','A185W012AS03','A185K00ABY07','A1856028AA06','A185B00GAV07','A1856028AA05','A185L00EAB03','A185V014AJ04','A185800MAD05','A185L00EAB01','A185W017BA05','A185W017BA03','A185800MAD04','A185J00QAU05','A185T02BBJ01','A185500WAD04','A185T02BBJ07','A185T02BBJ03','A185T02BBJ06','A185T02DBG05','A185T02DBG03','A185502JCG02','A185V033CE01','A185P00TBH03','A185N007AU05','A185V02AAH01','A185N007AU08','A185N006AP01','A185N006AP05','A185800SAG03','A185T021BU02','A185800SAG02','A185N009AQ07','A185400NCD08','A185501CBR06','A185M00ECA06','A1857019AD08','A185M00ECA04','A185M00ECA02','A185P01GAP06','A185P00LBE03','A185300ABB08','A185300ABB02','A185300ABB06','A185P00LBE02','A185400WAA08','A184T02GCF04','A185N00MBT05','A185L00BBF03','A185N00MBN06','A185L00BBF05','A185L00BBF06','A185N00JBP01','A185W00QCE05','A185900NCD04','A1854039BU07','A185800HCA01','A185T026CD08','A1857018BX02','A185C013BU06','A185H01RBU05','A1853003AQ01','A185400NCJ04','A1853003AQ07','A185T026BB07','A185H01RBU04','A185N007AU07','A185U00LAT03','A1853002AY01','A185200FBS05','A185X007BR08','A185X007BR01','A185W00GAH08','A185502FCK07','A1851013AP01','A184U00UBJ06','A185U022AJ05','A185R00VBX01','A185T021BB02','A185T021BB03','A185800FBL06','A1852005AU06','A185Q00WAC02','A185502MBU07','A185W00NAK05','A185M005CA05','A184V018AK07','A185N004AQ08','A184V018AK04','A185S015BT07','A185900JBH03','A185W00LBG05','A185V018AR07','A185W00PCA01','A185V018AR01','A185U024AD04','A1853003BC05','A185V015BH03','A185500WCG01','A185V016CE05','A1851026AM04','A185V02BCF01','A185V02BCF06','A1851026AM07','A1851026AM02','A184L01FCC03','A185601XBB02','A185601XBB05','A185601XBB04','A184L01FCC04','A185W012AC01','A184L01FCC01','A185W00KBW06','A185W012AB05','A185601AAT06','A185700HCF03','A185V015BV03','A185800SAX07','A185Q00NBR02','A185X00XCH06','A185V02CBB01','A185601RBD08','A185700VAG06','A185V02CBB02','A185601RBD06','A184U00UBJ01','A185K00CCF06','A185601RBD03','A185N008AN08','A184V02FCK04','A185502MAW03','A185502MAW05','A185Q00FBY01','A184V02FCK02','A185800KBS06','A185L00ABK02','A185800KBS07','A185N00CCJ01','A185701EAM06','A185L00BBG07','A185D00CBV06','A185800KBE07','A185700LAB06','A1853027CK06','A185L007AU05','A185L007AU03','A1852027AS03','A1857010BJ06','A184W022AU08','A185K00CCG03','A1852027AS01','A184W022AU01','A185900WCD08','A185900WCD06','A185T024AV02','A185R010BA07','A185T024AX08','A185700WAE05','A185T024AV07','A185S019BQ02','A1856020AC06','A1853002AB06','A185L00PCK04','A1853002AB08','A185700WAK03','A185L00FBM06','A1856020AC02','A1856020AC01','A1853002AB07','A185S010BW06','A185S010BW03','A185900NAW05','A185201WBD05','A185M00BCD01','A185M00EAA08','A184V015AG08','A185402UAX02','A185K00PAM03','A185402UAX08','A185501EAF06','A185500QBG06','A185500QBG07','A185500UCJ04','A185400NBS06','A185400NBS02','A185F00KBB03','A185500UCJ01','A185400NBS03','A185K00PBA07','A185K002AW04','A185K002AW03','A185400NBS05','A185R016AE02','A185402TAB05','A185800XAD06','A185L00MAB08','A1853005CK08','A185C013BR08','A185L00FBM02','A184T02FCD08','A1856003CC05','A185K003AD03','A185K003AD06','A185K003AD02','A185701CCD03','A185L00ACH07','A185701CCD04','A185400NBX06','A1853009BT02','A185K002BV08','A1853009BT05','A185J00QAQ05','A185C00RCH01','A1857012AJ08','A185J00QAQ08','A185J00QAQ04','A185800HCA08','A185K003AL01','A185R010BD03','A185200FBQ04','A185L00ACG01','A185T02ACE04','A1852023BY03','A185S012AG06','A1853003BA07','A185W014AJ08','A185W004AA07','A185W004AA04','A185V032BS08','A185M00BBR03','A185502FBS04','A185N00GAF01','A185Q00MBG05','A184T01QCJ03','A184T01TCD07','A185Q00MBG08','A1853015AU02','A185S01CAK03','A185502ABA05','A185502ABA04','A185502ABA06','A185R012CA02','A185T02ACE07','A1852023CA03','A185K00VAT04','A1852023CA01','A1857019BE07','A1853003BB04','A1857019BE05','A1853002AX05','A185U015BM01','A185U015BU04','A185402UBD03','A185U015BU03','A185200DAM03','A185200DAM05','A1853002AX04','A184T01QBN06','A185500UCD04','A185701CAB07','A184T01QBN07','A1854033BL02','A185L00ABD07','A185900XAX02','A184V02VBX05','A185402TCK05','A185T02CAR08','A185402TCK07','A185402TCK08','A185403CBM04','A185K004AJ08','A1853003CB08','A1853003CB02','A185402TCC05','A184T020AC06','A185502AAC02','A185P01BCF06','A185800FCD08','A185P017AD04','A185N00LBS03','A185P019CH04','A185400VBG05','A185500XBC08','A185W00GBD07','A185200HBX02','A1853024BT06','A185W005BU02','A185700AAJ04','A185J00NAY05','A185T029AT07','A185Q00DBC02','A185N00JAM08','A185P01GAV06','A185T029AT02','A185M007AM01','A185V018BB01','A185N00JAM02','A185N00GAY06','A185N00GAY08','A185V017CD08','A185800HBG06','A185502BCK07','A185502BCK01','A185800HBG02','A185P00TBK04','A185502JBH03','A1857013CK08','A185502JBH06','A185U00XAH04','A185W013BD04','A185800FCH02','A185500WBE08','A185T023AK08','A185502AAP06','A185500XBC04','A185502AAP07','A185800PAG08','A185C013BU01','A185P00LBK01','A185800PAG07','A185P00LBK06','A185800PAG03','A185800PAG02','A185800PCK03','A185L00MAV03','A185502JAL03','A185800PCK06','A185S01CBK02','A1851014BK05','A1851014BK03','A1851014BK01','A1856005BF01','A185M00CBM04','A185S019CG05','A1856005BF03','A185700LAS01','A185402TCJ01','A185S019CG01','A185M00EAF07','A185500WBE05','A185700LAS04','A185U00MBD08','A185U00MBD06','A185C01QBW06','A185C01QBW04','A185P01HAQ06','A185W013BL01','A185W013BS04','A1851013AD06','A185700LAU01','A185L00KAG03','A185K00XAB01','A185L00ACG08','A185T02BAT03','A1853001CG05','A185601XAH03','A185701EBW05','A185700EBL08','A185701EBW01','A185T02CAU06','A1853001CG02','A185701EBW02','A185800XAM07','A185U00YAW05','A185L00ABM06','A185L00ACE07','A1853024AT04','A185701EBM08','A185800NAH02','A185M00KAP07','A185S00XAB03','A185L00ACE02','A185800FBW01','A185T021AU05','A185W00FCG04','A185M00KAP04','A185W00FCE04','A185M00KBD01','A185T021AU01','A185M009BU08','A1854039AB01','A184V02WAG08','A185502LAU05','A185502LAU01','A185601BAX08','A185601BAX02','A185H027AD08','A1853002AF07','A1854033BJ05','A185300AAN07')";
        String hql4=hql.toString()+" and materialname in('A185300AAN03','A185M005AX05','A185300AAN04','A185M00KAA08','A185J00MBB08','A185N00GAP07','A185403CAM01','A1857018CA08','A185Q00PAA01','A184M01PCC01','A1853003CH06','A185400NCD04','A185R00YCC02','A1853003CH01','A184M01PBS01','A185200FAW07','A185R00YCC01','A185502LAR03','A185502LAR08','A185402TBX08','A183M00RBE08','A185601HAB08','A185900WBU05','A185900WBU08','A185700YAT01','A185700YAT02','A185M004AT06','A185M004AT08','A185800HBM03','A185800HBM08','A185M004AT01','A185M00JCE04','A1857016AV05','A185900TAL02','A185M004AR05','A185U013BA04','A185V02CBK07','A185W00GAW08','A185M004AR02','A185K00VAY03','A185401WAW05','A185W00GAW04','A185K00VAY02','A1853005AK02','A185M00KAR08','A185401WAW08','A185H00SBY08','A185U016AG08','A185H00SBY04','A185U023BJ02','A1854038BT07','A1854038BT02','A185502ABS08','A185700NAM03','A1854038BT04','A185N00GAP01','A185700NAM06','A185502ABS06','A185N00MBD04','A1856019CD03','A185500SBG07','A185500SBG08','A184N01EAV05','A1853017BT07','A185L00DCJ02','A185500SBG02','A185V018BK03','A1853017BT02','A185700EBU05','A185601JAR07','A185601JAR06','A185K00GBC06','A184T01LBB01','A185L00JAK03','A185800UBK08','A184T01LBB02','A185800PBC01','A185403EAC04','A185400VAW02','A185N00MBP04','A184T01VBK07','A185701ABQ07','A185701ABQ06','A185701ABQ02','A185L00RAA07','A185701ABQ01','A185W00GBE08','A185L00RAA03','A185S015BA04','A185M00CCA08','A1854039AY08','A184T01QBL01','A185M00CCA04','A184T01QBL04','A185400LAM01','A185G003BP07','A185L00DBB08','A185400LAM08','A185202JAH05','A185403EAG04','A185202JAH02','A1854033AQ05','A185K00GAR08','A185K00GAR03','A185400PAY06','A185400PAY08','A185K00GAR04','A185701EBQ02','A185G004AG08','A185N00DBY04','A185G01GCE07','A185F00FCB08','A185J00NCE05','A1854033AL03','A1854033AL06','A185U013AW07','A185J00NCE01','A185U013AW04','A185P00LBD08','A185U013AW03','A185502KBV01','A185502KBV04','A1855021AT01','A1855021AT08','A185K00BAM08','A185K00BAM05','A185K00BAM01','A185Q00FAK03','A1855022AY08','A185500SBP07','A185J00HCE03','A1855022BH02','A185K003BH08','A185500SBP04','A1855022BH01','A185K00GBC08','A185U016BE04','A185900NAE03','A185U016BE02','A185900LBJ03','A185900LBJ08','A185601YCE06','A185701CAX08','A185601YCE05','A185T02BAT07','A185701EAB01','A185701BAS07','A185701BAS01','A185701BAS04','A185T02FCA05','A185V018BQ01','A185T025BW06','A185T025BW05','A185L00AAQ03','A185V02CBU07','A185S016AV06','A185600SAC04','A185S016AV04','A1855022BV07','A1855022BV05','A185M007AW05','A185V033CE02','A185B00GBH06','A185B00GBH08','A185M008AH04','A185U015AV02','A185B00GBH07','A185U015AV07','A185J00TBU02','A185W00PCH07','A185W00PCH03','A185502NCE01','A1854039AC06','A185600SBR06','A185502NCE06','A1853002AP04','A185W00MAB07','A185M00DCJ01','A185U016BC04','A185800SBD06','A185T02CCC04','A185800SBD01','A185V02CAS01','A185T02CCC03','A185402TBA04','A185W00MBV03','A185W00MBV01','A185S010CH06','A185S010CH07','A185G01GCE05','A185L00BBS01','A185G01GCE04','A185L00BBS04','A185M005BF03','A185M005BF05','A184L01FCA03','A185G004CB08','A184M01PAF04','A185G004CB03','A185G004CB04','A185K00PBV06','A185K00UBN04','A185200FAU07','A1853015BE01','A185H00MBP06','A185L00NBG03','A185C00QAH03','A185400WBS05','A185V02BAN07','A185D00ECD01','A185400WBS03','A185800UAV02','A185800UAV03','A185501EBP02','A185N00JAQ03','A184T02JBP08','A185S019AV06','A185900WAT03','A184T02JBP03','A185S019AV02','A185601XAN04','A185402UAG07','A185L00DBF01','A1854029CJ05','A185M00BAA08','A185W016BL05','A185W016BL04','A185M00BAA01','A1854029CJ04','A185M00MAS06','A185C013CA01','A185501EBD01','A185502NBD02','A185V016AL07','A184V013CD06','A185T021AL07','A185L00KAK01','A185L00ABT02','A185V016AL01','A184V013CD05','A185400WAN03','A185S017AK05','A185G003AA04','A185C013CG05','A185601HBB07','A185501CCB01','A185W00MAG08','A185601HBB04','A1854039AF03','A185C013CH01','A185T027BQ02','A184V012BP02','A1854039AF08','A1855022CD06','A185800WAN04','A185502LAS03','A185S010BT03','A185502MBG01','A185T021AN03','A185T021AN05','A185C013AV08','A184V012BP01','A185C013AV06','A1857018AJ06','A185C013AV01','A185501ECJ03','A185502JAT05','A185Q00SBB06','A184V019CB02','A185Q00SBB03','A185K00XAF05','A185U022AV08','A185U022AV03','A185U022AV05','A184T01LBQ04','A185W005CB05','A185500WAK04','A185U00MAU03','A185N005AR01','A185V00MBM02','A185W005CB01','A184V02FAS06','A185K00PAL05','A185U00MAU01','A185H00LCE01','A185F006AR03','A185300AAY08','A185N00KBG04','A185V032BT04','A185S014CB04','A185F006AR02','A185G003AC07','A185K00SBA08','A185601CCG07','A185K00SBA05','A185601CCG08','A185K00SBA07','A1854039AP01','A1854039AJ04','A185U022AT03','A185U022AT02','A185K00PAL02','A1852038BE05','A185L00ABA04','A1854039AJ02','A185N005AL08','A185W005CG07','A185W005CG02','A185R017AL08','A185502JAC04','A185D00LAU08','A185G00SAQ06','A184N01BBA01','A185H00SBU04','A185L00FAK01','A185V019AW06','A185H00SBU01','A185P01DBR03','A185Q00PCB08','A185Q00PCB05','A185W014AA01','A185601GAC02','A185800HBQ08','A185601GAC04','A184V00XBP08','A184T01PAR08','A185V02BAX06','A185K004AE02','A185R017AL01','A185H00LCK03','A1857018CH05','A185W00KCK08','A1857018CJ01','A185H00MBC05','A1854010BP03','A1853026BK05','A185500SCF07','A185701BAB03','A185H00MBC08','A185P01EBA02','A185H00PBQ07','A185701BAB07','A1854010BP08','A185S01ABB03','A185R019AH01','A1856004AN02','A1851013BB08','A1856010AA08','A1856010AA01','A185601NCD04','A1854033CE06','A1854039CK04','A185400NAT03','A185601NCD05','A185400NAT01','A185R01BBC04','A185L00JBV05','A185R01BBC01','A185800NBG05','A185800NBG08','A185R018AD04','A1856010AH02','A185U015AY06','A185P01EAS07','A1855010CJ03','A185P01EAS04','A185M00HAB01','A1854039CA02','A185600SBR05','A185600SBR03','A185V017AY07','A185P01EAS01','A184V02ECE08','A184V02ECE03','A1856010BE08','A184V02ECE04','A1856010BE04','A1857019AV04','A1857019AV03','A185T021AP05','A185W00HAS07','A185W00HAS06','A1852027AD08','A184T01NAV03','A184T01NAV04','A185S01CAD04','A185V015AB05','A1854010BJ06','A185200KBL08','A185V015AB03','A185502BBT04','A185V015AB04','A1854010BJ03','A185402BBG07','A185402BBG04','A185S012BP01','A185402BBG03','A185403EBA04','A185S017AW06','A185403CBU05','A1854034BJ03','A1854034BJ05','A185K00HCF07','A1854034BJ06','A185S017AW04','A1852023CE06','A1852023CE03','A1852023CE02','A1853003CG07','A1857018CH06','A1857018CH08','A1857018CH02','A185401WBE06','A185200GAX08','A1857018CJ02','A185W014AC03','A185W014AC08','A185R016AY07','A185401WBE04','A185R016AY03','A185W014AC02','A185W004BD03','A185K00XBG01','A185K00XBG02','A185R00QBL08','A185W017CJ07','A185W00NAD01','A185W005CK06','A184T01PAA07','A184T01PAA01','A185A00RBY03','A185M00GBX05','A185V02ABR02','A185M00GBX08','A185403CBU04','A185C00RCG07','A1857012AA03','A185U015BS04','A185U015BS06','A185U011AS06','A185U015BS05','A185H00NBF08','A185600SAA07','A185600SAA02','A185D00CCA03','A185M00GBX06','A185D00CCA08','A185W00QAD06','A185A00LBK07','A184G00XBM05','A185T021AP02','A185800MAF07','A184T01LBP01','A184C017AL08','A185T029CH03','A184C017AL06','A1855010BF01','A1855010BF05','A185G004CA03','A185700LAF01','A185800MAN05','A185W00FCK08','A1852027AR02','A1852027AR06','A185700LBG08','A1852027AR07','A185400NAN08','A185400NAN05','A185W00JAX06','A185201TAS05','A185800SBB07','A185W00JAX01','A185800SBB08','A185800SBB03','A185201TAS08','A185800SBQ03','A1857012AA06','A185500SCK06','A185400QAR05','A185501EAQ08','A185S01AAV04','A185700NBE07','A185H00MCH02','A185501EAQ04','A185400QAR01','A185L00FBF08','A1852025AD05','A185K00XAK05','A185700NBE02','A1852025AD01','A185500SAN04','A1852007AA01','A185C01QCD08','A1856004AV08','A185501CCF05','A1856003BU05','A185200BAE04','A185200BAE06','A184H01GAH04','A185S01AAQ05','A185501EBD08','A185300BAC06','A185601HBK07','A185S01CAU03','A185V02CBL04','A185W00KBM08','A1856010AL05','A185T026CA03','A185502KBM04','A185N00JCK02','A184G00XCD05','A185P01HBT04','A185S01BCK02','A185501EBD04','A185S010AU06','A185S017BV08','A185C01KBQ05','A185W00GBT08','A185W012AS07','A1856010AL02','A185B00GAV01','A185B00GAV02','A185700HCH07','A185700HCH01','A185P00TBR07','A184V02FAR04','A184T02GCF02','A185J00QAU08','A185500WAD07','A184W027BN04','A185700GCC06','A185V033CE05','A1854039BS03','A1853009BT01','A185N006AP06','A185800SAG05','A185501CBR07','A185V017BY07','A184M01PAF05','A185403JBK01','A185P01GAP07','A185402TCE04','A185402TCE01','A185P00LBE05','A185700GCA07','A185700GCA03','A185L00BAT03','A185L00BAT01','A185N00MBT04','A185N00JBP05','A185N00JBP03','A185N00JBP06','A185P01BCD01','A185701ABJ06','A185701ABJ08','A185701ABJ07','A185W00QCE01','A1852023CB04','A185900NCD06','A185W004CG04','A1852023CB03','A1853002AY08','A185200FBS02','A185402TBA06','A1857018BX05','A184W026AP05','A185M00MAR02','A1854039BU06','A185M00MAR04','A185U00MAT08','A185C013BU03','A185L009BC03','A185K002BV02','A185T026CD04','A185T026BB04','A1854039BS08','A185P00TBH05','A1854039BS06','A184C017AD01','A185200FBS03','A185W00GAH07','A185K00VAY08','A185X00BBS06','A185W00GAH02','A185W00GAH05','A185402TBN08','A185W00GAH03','A185402TBN06','A185402TBN07','A185P01DBW07','A185502FCK04','A1851013AP03','A185A00RBL03','A185900UBC08','A185T021BB08','A185501CBH02','A185T021BB01','A185501CBH07','A185B00EBD08','A185502MBU05','A185W00NAK07','A185502MBU01','A185502NAH05','A185900TBP05','A185502NAH01','A185900TBP08','A185W00MCC06','A185S012AA01','A184V018AK02','A185U011BT06','A185U011BT03','A185V02ACJ01','A185V02ACJ06','A185N004AQ02','A1853003BC08','A185800HAN04','A185500WCG05','A1856010AM07','A185V017CH01','A185V015BH08','A1856010AM02','A1851026AM06','A185500WCG08','A185V02BCF04','A185W00LBJ05','A184L01FCC05','A185501CBK04','A1854029BP04','A185W012AC05','A184V01ACG02','A185601XBB06','A185400SBT08','A185T024BD05','A184V01ACG03','A185W00KBW05','A185601AAT07','A185700HCF05','A185200FCE04','A185200FCE03','A185W012AB06','A185V015BV07','A185P019BM06','A185601AAT04','A185601AAT08','A185P019BM07','A185P019BM01','A185T024AT07','A185800SAX06','A185X00XCH01','A185V031CA02','A185400YBR06','A185V02CBB08','A185700VAG08','A185N008AN06','A1851026AF02','A185601RBD07','A1851026AF01','A185T024BU01','A185K00CCF02','A185502MAW07','A185N00CCJ05','A185N00CCJ08','A185N00CCJ04','A185L00FCA05','A185T024AH08','A185800KBB03','A185D00CBV03','A185R010BG04','A185D00CBV04','A185L00BBG02','A185R00XAT01','A1852027AS08','A185L007AU04','A185700XAA08','A1857010BJ04','A185700XAA06','A185K00CCG01','A185K00CCG02','A185500UBK05','A185K002AX08','A185L00PCK07','A185L00PCK01','A1853009CF08','A185700WAE03','A185L00FBM05','A185700WAK02','A185700WAK04','A185900NAW06','A1853009CF01','A1853002AB02','A185L00PCK02','A1853009CF03','A185800XAD05','A185K00CBT05','A185M00EAA07','A185K00CBT01','A185900NAW02','A185M00EAA05','A185501EAF08','A185201WBD06','A185201WBD02','A185501EAF03','A185402UAX07','A185R01BAV04','A185402UAX06','A185500QBG08','A185L00MBF01','A185701EAY02','A185500UCJ08','A185500UCJ06','A185L00MBF06','A185701EAY06','A185N00GCG03','A185701EAY01','A185502ABT04','A185800XAD08','A185K002AW01','A185400PBA05','A185800XAD04','A1856011BV02','A185M00ABE04','A185601GAR06','A185L00BCH03','A1853026BT07','A185C013AX02','A185601GAR02','A185601GAR07','A185402TAM07','A185601GAR03','A1856003CC04','A185K003AD04','A185500SBX02','A185D00CAB05','A185D00CAB06','A185L00ACH03','A185701CCD07','A185700YAS07','A1853009BT08','A1853009BT06','A185J00QAQ01','A1857012AJ02','A185W00LBT03','A185W00LBT06','A185W00LBT08','A185M00KAN02','A185R010BD01','A185L00ACG03','A185200FBQ01','A1852023CK04','A1852023CK05','A185T02ACE06','A1853003CJ06','A1853003BA04','A185G010CK06','A185K00HBN06','A185502FBS07','A185K00HBN01','A185S01CAD02','A184T01TCD06','A1853015AU01','A1853015AU08','A1853015AU06','A1853003BB06','A1852023CA05','A185K00VAT02','A185400MBC02','A185U015BM06','A185L00RAB08','A185U015BU07','A185U015BU08','A1853008AA08','A185701CAB08','A1853002AX07','A1853008AA04','A184T01QBN04','A1854033BL05','A185701CAB03','A184T01QBN05','A185Q00QAU03','A185500UCK05','A1853008AA03','A1853024BK01','A1853024BK06','A185L00ABD02','A185402TCC06','A185L00EAW07','A185601NAU05','A1853024BK02','A185403CBM02','A185601NAU08','A184T020AC08','A185601NAU01','A185800LCJ05','A185502AAC01','A185800LCJ08','A185800FAA04','A185800FAA01','A185800FAA06','A185800FCD05','A185500YAK01','A185200HBX05','A185500YAK03','A185500XBC07','A185502AAP08','A185200HBX07','A185W00GBD05','A185Q00DBC07','A185800LCG06','A185M00MAQ04','A185N00JAM05','A185900JBF02','A185F00BBV07','A185700YAV04','A185F00BBV08','A185700YAV08','A185M00EAT07','A185M00EAT08','A185M00EAT05','A185U00XAH07','A185W013BD03','A185U00XAH06','A185800FCH03','A185K00UAJ05','A1856029BE06','A185500XBC03','A185502AAP02','A185W00GBD02','A185701BAY08','A185800PAG06','A185800PAG05','A185S01CBK05','A185L00MAV06','A185C00QAL05','A185800PCK05','A185K00UAQ03','A185M00CBM08','A185M00CBM03','A1856005BF04','A185U00YBS05','A185T02BCJ08','A185U00YBS07','A185U00YBS08','A185402TCJ02','A185T02BCJ06','A1856005BF02','A185U00YBS02','A185M00EAF05','A185700LAS03','A185N00MBL02','A185T026BJ04','A185700LAU03','A185C01QBW02','A185L00KBR08','A185700LAU02','A185P01HAQ03','A185M00EAF01','A185900JAY06','A1853001CG01','A185T02CAU02','A185U022AF06','A185800XAQ06','A185800XAQ04','A185800XAQ02','A185U022AF01','A185L00RAB03','A185701EBM04','A185L00ABM01','A1853024AT05','A185U00YAW01','A185800NAH04','A185M00KBD07','A185800FBW06','A185U00MAF04','A185502LAU03','A184V02WAG04','A185H025BT06','A184M01SBB07','A1853002AF04','A185H027AD01','A185H027AD02','A185H027AD03','A185501EAB02','A185501EAB08','A185501EAB07','A185J00KAR03','A184T01YBM01','A1855022AP08','A185K004AP08','A185M00KAA02','A185P00LBD03','A185M00KAA04','A185K004AP06','A185J00MBB03','A185J00MBB04','A185P01CAK05','A1857010BP05','A185400SAK06','A184M01PCC06','A184M01PBS06','A184M01PCH01','A1857018CA05','A1853003CH05','A185W015BT01','A185200FAW01','A185200FAW03','A1857011BK02','A1857018CA01','A185200FAW04','A185Q00LBQ01','A185Q00LBQ05','A185502LAR02','A185402TBX04','A185800FCC04','A185601HAB02','A185800FCC05','A185M00DAE08','A185900WBU06','A185M00DAE06','A185M00DAE04','A185700YAT06','A185700YAT08','A185W00FCD01','A185900TAL07','A185M004AT02','A185800HBM07','A185U025CA05','A185U025CA07','A185M004AR03','A1857011AW08','A1857011AW04','A185U014AT08','A185K00VAY07','A1857011AW02','A185K00VAY05','A185U014AT02','A185K00VAY04','A185U014AT05','A185402UAJ01','A185502ABS03','A185N00GAP04','A185W00KAR06','A184T02EAT03','A184T02EAT01','A185L00DCJ01','A185V018BK06','A185V018BK01','A1857015BY07','A1854039AY07','A185202VCJ06','A185202VCJ04','A185700EBU01','A185202VCJ05','A185700EBU08','A185K00GBC04','A184T01LBB06','A184U00UAQ07','A185K00GBH01','A185L00JAK01','A185E00QBJ07','A185A00SAR03','A185V01AAX03','A185N00MBP06','A185V01AAX02','A185N00MBP01','A185403EAG07','A185U016AG03','A185701ABQ04','A185W00GBE03','A185S015BA05','A184T01QBL07','A184T01QBL03','A184T01QBL06','A185V00MAN06','A185M00CCA02','A185501EAM08','A185501EAM03','A185M00ACC04','A185G003BP06','A185403EAG06','A185700GAX01','A185400PAY04','A185800HBT07','A185400PAY05','A185400PAY07','A185800HBT08','A185K00GAR06','A185400PAY03','A185E00QBJ02','A185E00QBJ03','A1854029AA08','A1854029AA07','A185M008AT08','A185K00DAV05','A1854029AA06','A1854033AL04','A185403CAM05','A185502KBV07','A185502KBV05','A185501EAM05','A1855021AT03')";
        String hql5=hql.toString()+" and materialname in('A185G003BP03','A185K00BAM06','A185M00ABY08','A185G003BP01','A185K00PAY07','A185500SBP08','A185K00PAY05','A185403EBU04','A185K00PAY08','A185H00NBG01','A185K003BH01','A185K00GBC07','A185900NAE07','A185U013BA03','A185U013BA05','A185601YCE02','A185601YCE03','A185701CAX06','A185900JAY07','A185701CAX07','A185T023AL02','A185T02FCA06','A185V018BQ02','A185601GAN04','A185V018BQ05','A185T02FCA02','A185601GAN07','A185T02FCA04','A185V02CBU04','A185T025BW04','A185G01GAD03','A185L00AAL02','A185L00EAU08','A1854039AB03','A185S01CAK02','A185600SAC01','A185M007AW03','A185S016AV02','A1855022BV03','A185M007AW01','A185M008AH01','A185502LAW04','A185B00GBH05','A185U015AV04','A185J00TBU05','A185800PBK02','A185J00TBU04','A185800PBK05','A185J00TBU08','A185U015AV03','A185W00PCH08','A184W00JAT07','A185502NCE08','A185700GBM06','A185700GBM04','A185601RCG08','A1854039CA05','A185601RCG04','A185403CAC05','A185M00DCJ05','A185800SBD03','A185T02CCC06','A185V02CAS08','A184U00YBA04','A184U00YBA07','A185V02CAS06','A185J00SCA02','A184U00YBA08','A185V00LBA07','A185Q00PAU08','A184V02FBE01','A185S012BJ06','A185V032AF04','A184L01FCA02','A1853003CG01','A185L00BBS02','A185G004CB07','A185K00PBV05','A185200FBX02','A185K00PBV04','A185200FBX01','A185K00UBN05','A185M00ECA07','A185V02BAN06','A185800NAK03','A1853015BE05','A185800NAK04','A185700YAD04','A185V02BAN08','A185H00MBP04','A185D00ECD04','A185C00QAH02','A185N00JAQ07','A1853001BE03','A185N00JAQ06','A1853001BQ05','A185900WAT05','A185700BAS02','A185700BAS03','A185601XAN06','A185S019AV03','A185L00DBF06','A185701BCK07','A185403CAP06','A1854029CJ07','A185K00TAG07','A185K00TAG03','A185M00BAA04','A1854029CJ08','A1854029CJ01','A185C013CA07','A185W00KBF02','A185C013CA05','A185800WAN03','A1852023CC01','A184M01PBT07','A185T00ABN03','A185400PAG06','A185400WAN01','A185R00XCC07','A185601HBB08','A185601HBB05','A185G003AA08','A185501CCB08','A185G003AA01','A185C013CG06','A185C013CH07','A185601HBB02','A185T027BQ08','A1855022CD07','A1855022CD08','A185M00EAM01','A185S017AK06','A185601HAD08','A185601HAD07','A185403JAN06','A185502LAS07','A185S017AK02','A185601HAD04','A185502LAS05','A185T02EAJ01','A185403JAN01','A184V019CB03','A185502JAC07','A185C013AV03','A185501ECJ05','A185501ECJ06','A184V019CB01','A185C013CD07','A185T02CCB04','A185U012BM03','A184T01LBQ06','A185K00XAF06','A185K00XAF01','A185502JBF02','A185U022AV01','A185500WAK07','A185U00MAU05','A184T01LAM06','A1854039AP08','A185U022AT05','A1854039AP03','A185K00PAL06','A185502JAF01','A185502LAS04','A185200FCD06','A185N00KBG08','A185502JAF02','A185200FCD05','A185900WAU07','A185V032BT02','A185G00KAY06','A185G003AC06','A185S01AAQ08','A1854039AP06','A185800LCG05','A185W005BU05','A185V02AAF04','A1853024BT03','A1852038BE02','A185502JAC06','A185T009AL05','A185G00QAB07','A185800WAU02','A185N006CC06','A185M005AA08','A185W00HAP08','A185600SBS04','A185M005AA06','A185M005AA01','A185600SBS05','A185V019AW05','A185200FBD08','A1853017AG03','A185200FBD01','A185W00HCC04','A185Q00PCB04','A185W00HCC01','A185W014AA06','A185800HBQ04','A185601GAC06','A185K004AE06','A184T01PAR04','A185W00KCK07','A185K00XBE08','A1857018CJ05','A1853005AF06','A1853005AF07','A185H00MBC07','A185J00QCK07','A185H00MBC06','A185701BAB04','A185701BAB01','A185701BAB02','A185403CAX06','A185500SBY04','A185R019AH03','A185700YBA06','A185R01BBC07','A185R019AH04','A185500UCH07','A1856004AN04','A1851013BB01','A1854039CK01','A185C00QAE06','A185C00QAE02','A185U014BD06','A185403CAK01','A185403CAK07','A185K001BL01','A185R01BBC08','A185U015AX05','A185R01BBC06','A185401WAR07','A185U015AX03','A185401WAR04','A185L00NBU01','A1855010CJ04','A1856010AH08','A185500UBQ04','A185P01EAS03','A185502NCE04','A1852023CH06','A1853003BU01','A185V017AY05','A1857019AS03','A185502KAF08','A1857019AS04','A185T009AQ03','A1857019AS06','A185L00FAQ05','A185U015AU02','A1857018CG02','A185S00XCG03','A185502FBT01','A184T01NAV08','A185S00XCG06','A185S01CAD07','A1852027AD02','A185V018BA07','A185V018BA04','A185601NCD01','A185502BBT08','A185S012BP03','A1854038AR08','A185402BBG06','A185S017CF08','A1854038AR02','A185S017CF03','A185500SAT06','A1857019AX03','A1857019AX05','A185M00KAE08','A185500SAT04','A185C013BY07','A185W00FBE07','A184W00JAS05','A1852023CE08','A185V00MCC07','A1853003CG06','A185V00MCC02','A185V00MCC06','A185500WAQ01','A185S012BJ08','A185T029CK06','A1853005AF03','A185200GAX06','A185R016AY08','A185900JBN04','A185K00XBE04','A185W004BA08','A185900VBN04','A185K00XBG03','A185W017CJ05','A185W00NAD05','A185W00NAD04','A185R00QBL06','A185V02ABR06','A185W005CK01','A1854034BJ02','A185K00HCF01','A185S01CBJ04','A185C013BY06','A185500SAT02','A185600SAA06','A185U011AS08','A185403CCE01','A185400PCA06','A185C00RCG08','A185C00RCG06','A184500VAL04','A1857018AT07','A185W00QAD02','A185701FCH05','A184G00XBM04','A185S01AAR03','A185S01AAR05','A184G00XBM01','A185W013BX07','A184H01GAH05','A185800MAN08','A185800MAF01','A185700LAF08','A185401WBQ06','A185800MAN06','A185G004CA06','A185700LAF03','A185700LBG01','A185800SBF05','A185W00JAX08','A185700LBG02','A185800SBF04','A185800SBF02','A185800SBB05','A185S01AAV05','A185S01AAV03','A185501DBS08','A185H00NBF01','A185700NBE03','A185501DBS06','A185H00MCH05','A1852025AD07','A184T02BAV03','A185700NBE04','A185K00XAK08','A1852025AD04','A185V02BAB07','A1856004AV04','A185500SAQ06','A1852007AA07','A185K00XAK04','A1852007AA03','A184T02BAV02','A184T02BAV04','A185C01QCD04','A185502KBM06','A185T026CE07','A185C01KBV04','A185200BAE07','A185C01KBV03','A185501CCF06','A185501CCF08','A185L00CAU01','A184H01GAH06','A185501EBD06','A185T02FBT01','A185300BAC07','A185300BAC08','A185300BAC05','A185W00GAJ05','A185V02CBL07','A185P01BAP02','A185P01BAP08','A1856010AL06','A185V02CBL02','A185K00TAL04','A185502KBM07','A185K00ABX01','A185N00JCK03','A185S01AAQ01','A185N00AAA02','A184G00XCD02','A185R016BE05','A185501EBD03','A185V02CAY08','A184M01PAN01','A185701CAW01','A185S017BV01','A185S017BV05','A185701CAW02','A185S010AU03','A185L00ABT07','A185S00VAV02','A185W00GBT04','A185W012AS06','A185W00GBT02','A185V014AJ01','A185V014AJ05','A1856028AA02','A184V02FAR02','A185V014AJ08','A185K00SAS04','A185J00QAU03','A185601GAH07','A185500WAD08','A185J00QAU04','A185J00QAU02','A185500WAD06','A185700GCC05','A184W027BN06','A185700GCC04','A1854039BS01','A185800SAG08','A185N007AU06','A185V02AAH07','A185N006AP03','A185800SAG06','A185N006AP08','A185N009AQ03','A1856003BT03','A185501CBR01','A185402TCE06','A185701AAV08','A185200FAU01','A185M00ECA08','A185403JBK07','A185P00LBE06','A185300ABB04','A185P00LBE01','A185400WAA06','A185700GCA04','A185L00BAT08','A185L00BAT06','A185700GCA02','A185L00BAT04','A185400WAA07','A185400WAA02','A185N00MBT01','A185L00BBF01','A185P01BCD06','A185P01BCD05','A185S010CH02','A185701ABJ03','A185900NCD07','A185900NCD01','A185900NCD03','A1852023CB07','A185200FBW02','A185K003AL02','A1857018BX01','A184W026AP04','A1853003AQ08','A185400NCJ06','A185400NCJ07','A1853003AQ06','A185U00MAT02','A185T026BB08','A185T026BB01','A185Q00LAR03','A185U00LAT05','A185W016CA07','A185W00MBV04','A185W016CA03','A185402TBN01','A185402TBN04','A1851013AP07','A1851013AP06','A1851013AP02','A185P01DBW08','A185U022AJ02','A185W00FBL01','A185U022AJ01','A185900UBC04','A185900UBC01','A185501CBH08','A185800FBL01','A185T021BB05','A185800FBL02','A185Q00WAC08','A185502MBU02','A185W016CA04','A1852005AU02','A185W00MCC05','A185900TBP07','A184V018AK06','A185R015CA04','A185U011BT08','A185V02ACJ03','A185900JBH05','A185900JBH01','A185U011BT02','A185U024AD02','A185V018AR03','A185W00PCA02','A185V031CA07','A185800HAN05','A185800HAN01','A1853003BC07','A185V015BH02','A185V02BCF03','A185V02BCF02','A185501CBK08','A185501CBK06','A185501CBK03','A185W00LBJ01','A185501CBK05','A1854029BP06','A185501CBK02','A185W00LBJ02','A185601XBB01','A184V01ACG07','A185W00HAH03','A185W00HAH06','A185W00KBW03','A185700HCF04','A185V015BV05','A185200FCE02','A185601RBN07','A185601RBN01','A185601RBN02','A185400YBR05','A185X00XCH08','A185V02CBB06','A185700VAG05','A185K00CCF03','A185N008AN01','A185N008AN02','A185K00CCF01','A1851026AF06','A185T024BU05','A184V02FCK08','A185502MAW02','A185L00ABK08','A185Q00FBY07','A1851026AF04','A185L00ABK01','A185L00ABK06','A184V02FCK06','A184V02FCK05','A185R010BG07','A185D00CBV01','A185L00BBG06','A1853027CK02','A1853027CK04','A185701EAM01','A185K00CCG05','A185701EAM02','A185502ACA06','A184W022AU05','A185700XAA01','A185H02BBD03','A185K00XAL04','A185900WCD07','A185900WCD03','A185K002AX03','A185700WAE08','A185T023AW04','A185T024AX01','A185T024AX03','A185K00XAL02','A185K002AX02','A185S019BQ03','A185500UBK01','A185500UBK02','A185800XAD07','A1856020AC04','A185700WAK06','A1856020AC03','A185900NAW08','A185K00CBT03','A185M00BCD08','A185900NAW01','A185201WBD04','A185402UAX03','A185K00PAM07','A185K00PAM04','A185501EAF02','A185M00EAA02','A185K00PAM02','A185402UAX04','A185400NBS04','A185502ABT06','A185K002AW07','A185M006AN05','A185K002AW06','A185K002AW08','A185402TAB06','A185502ABT02','A185800XAD01','A185K00PBA08','A185400PBA04','A185400PBA07','A185K00PBA04','A185M00ABE06','A185601XAB05','A185601XAB08','A185M00ABE08','A1856011BV07','A1856011BV05','A1854039BY04','A1854039BY06','A1856011BV01','A185800XAD02','A185402TAM04','A1854039BY05','A1854039BY03','A185L00MAB06','A185L00MAB02','A1853026BT02','A185C013BR07','A185L009BF07','A185402TAM05','A185H00UAF01','A1853005CK01','A185K003AD07','A184T02FCD03','A185K003AD05','A185500SBX04','A185500SBX07','A185D00CAB01','A185403EAP08','A185403EAP06','A1857012AJ04','A1857012AJ03','A185700YAS06','A185403EAP05','A185C00RCH07','A1853009BT03','A185800HCA06','A185M00KAN05','A185K003AL07','A185W00LBT05','A1854039BU08','A185R010BD04','A185G010CK07','A185R010BD02','A1852023CK03','A185G010CK08','A185T02ACE02','A1852023CK07','A1853003CJ02','A1852023BY07','A185S012AG05','A185S00VBH03','A185W013BR05','A185W013BR07','A1852023BY08','A185W014AJ03','A185W014AJ06','A185W004AA08','A185V032BS05','A185K00HBN05','A185M00BBR06','A185S01CAK05','A184T01TCD02','A185Q00MBG02','A1852023CA08','A185K00VAT06','A1853003CJ05','A185W013BR04','A185J00QAN08','A1857019BE02','A185U015BM03','A1853025AE04','A185Q00QAU08','A1853002AX06','A185402UBD07','A185402UBD01','A1853002AX01','A185400NBR03','A185400NBR07','A184T01QBN03','A185500UCK06','A1854033BL06','A184V02VBX06','A185402TCH08','A185402TCH03','A185500UCK02','A185402TCC02','A185L00ABD01','A185402TCC01','A185403CBM06','A185T02CAR06','A1853003CB06','A185T02CAR02','A1853003CB04','A185501CBR08','A185K004AJ07','A185502AAC03','A185800LCJ01','A185800LCJ06','A185800LCJ02','A185800FCD06','A185800FCD04','A185500YAK08','A185200HBX06','A185500YAK06','A185U00WCC05','A185U00WCC01','A185U00WCC04','A185500XBC06','A185400VBG01','A1853024BT01','A185M007AM05','A185T029AT01','A185900JBF04','A185V018BB04','A185N00JAM06','A185M007AM06','A185V017CD04','A185F00BBV05','A185N00GAY07','A185F00BBV01','A185V017CD07','A185P01GAV03','A185800HBG05','A185800HBG04','A185P00TBK02','A185502BCK04','A185502BCK02','A1856029BE03','A185T023AK07','A185T023AK03','A185T023AK06','A185M00CBM07','A185502AAP04','A185502JAL06','A185C00QAL01','A185L00MAV02','A185C00QAL02','A185502JAL08','A185S01CBK08','A185502JAL07','A185502JAL05','A185800PCK02','A1851014BK08','A185402TCJ08','A185500WBE04','A1851014BK06','A185K00UAJ07','A1851014BK04','A185M00CBM06','A185T02BCJ05','A185U00YBS03','A184V029CB01','A185400NCF06','A185400NCF04','A185400NCF05','A185700LAU08','A185700LAU05','A185W013AD03','A185M00EAF02','A185T026BJ02','A185P01HAQ01','A185W013BS08','A185L00KAG08','A185700LAU06','A185K00XAB08','A185601XAH05','A185900JAY08','A185701EBW03','A185T02BAT01','A185700EBL01','A1853001CG08','A185700EBL07','A185T02CAU01','A185701EBM05','A185800XAM05','A185L00RAB04','A185800XAM04','A185800FBW03','A185L00ABM04','A185L00ACE08','A185701EBM03','A185800NAH08','A185S00XAB04','A185M00KAP08','A185U00MAF02','A185601BAX07','A185601BAX05','A185601BAX04','A184M01SBB08','A184M01SBB05','A1853002AF03','A1854033BJ02','A1854033BJ07','A184M01SBB04','A185J00KAR08','A1855022AP02','A185K004AP03','A1857010BP02','A1857018CA07','A184M01PCH07','A184M01PCH03','A1857018CA03','A1853003CH07','A1853003CH08','A185200FAW05','A185R00YCC05','A184M01PBS08','A185400NCD05','A185R00YCC03','A184M01PBS05','A185300AAX02','A1857011BK04','A1857011BK01','A185L00JAK06','A185402TBX07','A185502LAR05','A183M00RBE06','A185800FCC03','A185800FCC06','A183M00RBE01','A185M00DAE05','A185900WBU04','A185700YAT04','A185800HBM02','A185U025CA08','A185M00JCE05','A185U025CA06','A185S00XAB07','A185900TAL08','A1857016AV07','A185M004AR07','A185M004AR08','A185U014AT06','A185W00GAW01','A185V02CBK04','A185U014AT07','A185W00GAW06','A185V02CBK08','A1853005AK07','A185H00SBY03','A185K00VAY01','A185M00KAR04','A1853005AK03','A185U023BJ05','A185M00KAR06','A185U023BJ07','A185U023BJ04','A185P01CAK03','A185502ABS01','A185P01CAK01','A185N00MBD03','A185S014CC07','A1854033AS05','A185T02GBR01','A1856019CD01','A185400SAY08','A185L00DCJ07','A1856019CD07','A185V018BK08','A185500SBG01','A1853017BT04','A184T02EAT04','A185601JAR08','A185202VCJ02','A185502LAN06','A185502LAN01','A185202VCJ08','A185700EBU02','A185601JAR02','A184T01LBB03','A184T01LBB04','A185M006AM05','A185400VAW08','A185A00SAR06','A185A00SAR07','A185N00MBP07','A185701ABQ05','A185U016AG05','A185L00RAA02','A185L00RAA01','A185L00LBV05','A185R00WCC04','A185501EAM04','A184T01QBL05','A185501EAM06','A1854039AY01','A185V00MAN04','A185V00MAN03','A184T01QBL02','A1856019CB02','A185M00ACC03','A1856019CB08','A1856019CB04','A185L00DBB06','A185601XCJ05','A185700GAX06','A1854033AQ07','A185K00GAR05','A185701EBQ07','A185800HBT01','A185701EBQ06','A185M008AT07','A1854029AA01','A185L00LBV02','A185F00FCB07','A185K00DAV02','A1854029AA02','A1854010AX07','A1854010AX02','A185J00NCE03','A1854033AL07','A1854010AX03','A185K00SAA03','A185F00FCB02','A185K00SAA06','A185J00KAR05','A185K00SAA04','A185502KBV02','A185Q00FAK04','A185500SBP01','A185403EBU06','A1855022AY01','A1855022AY06','A185500SBP06','A185K00PAY04','A185K003BH04','A185L00JAK08','A185900NAE06','A185900NAE01','A185U011AU08','A185701EAB08','A185900JAY05','A185T02FCA01','A185V018BQ08','A185G01GAD05','A185601GAN05','A1854039AB04','A185T025BW07','A185L00AAQ08','A185900TAN05','A185L00AAQ07','A185L00AAQ02','A185502ABA01','A184V00DBC08','A185600SAC05','A185600SAC02','A184V00DBC05','A184V018AR04','A184V00DBC03','A184V018AR02','A184W027BN05','A185700VBC04','A185M008AH06','A185W00PCH01','A184W00JAT01','A185601RCG06','A185700GBM03','A185L00EBD02','A1854039CA06','A185601RCG03','A1853002AP08','A185403CAC06','A1853002AP06','A185800PBK03','A185M00DCJ03','A185M00DCJ08','A185800SBD05','A185T02CCC07','A185202HAW07','A185W00MAB08','A185202HAW08','A185800SBD04','A185T02CCC02','A185202HAW02','A185J00SCA05','A184U00YBA06','A185800WBB04','A185800WBB07','A185Q00PAU07','A185S010CH08','A185V00LBA03','A185V00LBA05','A184V02FBE03','A185V032AF02','A185L00BBS08','A185L00BBS06','A185L00BBS05','A185M005BF01','A184M01PAF07','A185200FBX06','A185G004CB01','A185200FAU03','A185K00UBN08','A185W017BA06','A184V02FAR08','A1853015BE03','A185800NAK01','A185700YAD02','A185L00NBG07','A185L00NBG08','A185L00NBG01','A185H00MBP07','A185C00QAH04','A185H00MBP01','A185C00RCB05','A1856003AF04','A1853001BE08')";
        String hql6=hql.toString()+" and materialname in('A1856003AF05','A1856003AF03','A1853001BE06','A185W00KAM02','A1856003AF01','A185900WAT07','A1853001BE04','A185700BAS05','A185700BAS06','A185900WAT04','A185601XAN08','A184T02JBP01','A185500UBV06','A185403CAP08','A185403CAP01','A185402UAG06','A185601XAN03','A185601XAN07','A185K00TAG08','A185601XAN01','A185M00BAA07','A185500UBV02','A185K00TAG04','A185M00MAS05','A185C013CA08','A185C013CA03','A185701BCK02','A185L00ABT08','A184M01PBT02','A185V016AL06','A185V016AL03','A185T021AL01','A185400WAN05','A185G003AA06','A185G00PAE07','A185G00PAE01','A185501CCB06','A185G003AA05','A185C013CH05','A185C013CH03','A185C013CH08','A185T027BQ06','A1854039AF04','A185501EAL07','A184V012BP03','A185C013CA04','A185C013CA02','A185W016BL01','A185W00KBF07','A185M00EAM03','A185M00EAM05','A185W016BL02','A185K00XAF07','A185T02CCB07','A1855022CD01','A184T01LBQ07','A185G00NBA01','A185T021AN07','A185502MBG06','A185S010BT02','A185403JAN03','A185800HCG07','A185502LAS08','A185502LAS01','A185T021AN01','A184T02CBY01','A184T02CBY08','A185502JAT07','A185502JAT02','A184V019CB07','A185U022AV06','A185V00MBM01','A185V00MBM03','A185W005CB07','A185U00MAU04','A185K00VBS05','A184V02FAS04','A185W005CB02','A185K00PAL04','A185P018CH04','A185S018CF04','A185S018CF01','A185H00LCE07','A185502LAS02','A185N00KBG05','A185502JAF08','A185701FAH08','A185701FAH03','A185N00KBG02','A185S014CB07','A185701FAH01','A185F006AR06','A185G00KAY03','A185G00KAY08','A185900WAU06','A185G003AC08','A184V00XBP05','A185H00MBL05','A185H00MBL01','A185H00MBL02','A185400MCB02','A1854039AJ06','A185L00ABA06','A185402UBR08','A1854039AP04','A185L00ABA03','A185402UBR06','A185700AAJ05','A185W005BU03','A185N005AL01','A185800LCG04','A185W005BU01','A185800WAU03','A185G00QAB02','A185D00LAU05','A185800WAU06','A185D00LAU03','A185W005CG08','A185G00SAQ05','A185D00LAU04','A185W00HAS03','A185M005AA07','A185L00FAK08','A185W00HAP07','A185P01HAT07','A185200FBD07','A185P01HAT03','A185P01HAT01','A185W014AA07','A184N01BBA02','A185H00LCK06','A185U00YBY07','A185U00YBY03','A1857018CJ04','A185T029CK07','A185U00YBY05','A185T02BCG08','A1857019CK01','A185401WBS01','A1853026BK01','A185H00LCE02','A185H00PBQ06','A185S01ABB07','A185S01ABB05','A185701BAB06','A185S01ABB04','A185500SBY05','A185M00HAA03','A185403CAX03','A185500SBY06','A185S01ABB02','A185R019AH06','A185C013CD08','A1856004AN06','A1856004AN01','A185C00QAE04','A185C00QAE01','A185V01BBD08','A185400NAT07','A185601NCD08','A185400NAT05','A185U014BD03','A185403CAK03','A185L00JBV08','A185K001BL02','A185L00JBV06','A185800NBG07','A185R018AD05','A185R018AD03','A185401WAR06','A1855010CJ02','A1855010CJ08','A1856010AH06','A185501CCH05','A185P01EAS06','A185500UBQ03','A1852023CH08','A1853003BU07','A1857019AS07','A185800UBH06','A184V02ECE02','A185T009AQ05','A185T009AQ07','A185502KAF01','A185502KAF02','A185U015AU05','A185P00QBK07','A1857019AS02','A185800UBH05','A185T009AQ04','A185T009AQ01','A185800UBH01','A185W00HAS04','A185L00EBD03','A1857018CG01','A185502FBT04','A1852027AD05','A185502FBT03','A185S00XCG02','A185V018BA08','A185W014AJ05','A1854033CE02','A1854010BJ08','A185502BBT06','A185T02CBC03','A185T02CBC05','A185502BBT01','A1854010BJ07','A1854038AR05','A185S016AY02','A185S016AY01','A1857019AX06','A1854038AR04','A185K00HCF08','A185C013BY05','A185W00FBE08','A184W00JAS01','A185W00FBE02','A1852023CE05','A1852023CE01','A185Q00MAT01','A185Q00MAT02','A185200GAX04','A185200GAX05','A185900JBN06','A185W014AC05','A185K00XBE01','A185502NAF01','A185W004BA03','A185R00QBL01','A185R00QBL04','A185W017CJ03','A185W004BA04','A185M00GBX07','A185600SAA08','A185S01CBJ01','A185403CCE04','A1857012AA08','A1857012AA07','A185U011AS04','A185C00RCG03','A185500SCK07','A185500SCK08','A185S01AAV07','A185C00RCG02','A185500SCK03','A185K00SCJ07','A185M00GBX02','A185W00QAD03','A185W00QAD01','A185K00SCJ06','A185701FCH04','A185W00GAL02','A185701FCH06','A185700HAA01','A185701FCH07','A184G00XBM03','A185800MAF08','A185800MAF05','A184G00XBM02','A185S01AAR01','A184C017AL01','A185401WBQ07','A185401WBQ08','A185401WBQ04','A185800MAN07','A185W00FCK01','A185800MAN03','A1852027AR03','A185400NAN02','A185700LBG07','A185W00JAX03','A185800SBB04','A185800SBQ02','A1857012AA01','A185501DBS02','A185S01AAV02','A185501EAQ06','A185L00FBF06','A1856004AV01','A185K00XAK03','A184T02BAV05','A185K00XAK06','A185C01QCD03','A185K00TAL07','A185700LAF06','A185T026CE08','A185C01KBV05','A185C01KBV07','A185C01KBV06','A1856003BU07','A185300BAC04','A185201TAS01','A185601HBK06','A185S01CAU06','A185W00KBM05','A185W00KBM07','A185W00KBM06','A185A00LBK05','A185A00LBK01','A185500SAN02','A185W00KAM08','A185W00KAM03','A185N00AAA04','A185S01BCK07','A184G00XCD04','A185R016BE08','A185R016BE07','A185T009AD03','A185T009AD02','A1852023CC08','A1856010AL01','A185T026CA01','A185K00ABY05','A185700HCH06','A185K00ABY03','A185K00RBV07','A1856028AA04','A185700HCH05','A185K00RBV06','A185800MAD06','A185U016BC01','A185J00QAU07','A185601GAH08','A185T02DBG07','A185T02BBJ04','A185500WAD03','A184W027BN07','A185502JCG07','A1854039BS02','A185N007AU03','A185V02AAH05','A185N007AU04','A185N006AP04','A185502AAC06','A185502AAC08','A1856003BT05','A185400NCD06','A185V017BY03','A185501CBR04','A184N01BBH02','A185K00UBN02','A185701AAV05','A185403JBK05','A1857019AD01','A185P01GAP05','A185402TCE08','A185402TCE03','A185700GCA08','A185N00JBP07','A185N00MBN04','A185K00SAS07','A185K00SAS01','A185U016BC07','A185P01BCD04','A185U016BC08','A185502BAR07','A185502BAR04','A185900NCD05','A185W004CG03','A185502BAR05','A1852023CB02','A185200FBS07','A185200FBW06','A184C017AD03','A1852023CB01','A184C017AD02','A1853002AY02','A185200FBS06','A185800HCA03','A185M00MAR07','A1854039BU01','A1854039BU02','A1857018BX04','A185C013BU05','A185L009BC02','A185H01RBU07','A185L009BC01','A185400NCJ08','A185400NCJ05','A185H01RBU06','A185H01RBU08','A185200FBS08','A1853002AY05','A185W016CA08','A184M01PBL02','A185Q00WBD02','A185Q00WBD03','A1851013AP04','A185P01DBW04','A185900UBC06','A185A00RBB02','A185U022AJ07','A185R00VBX07','A185A00RBB07','A185A00RBB01','A185900UBC07','A185501CBH04','A185501CBH01','A185501CBH05','A185502NAH04','A1852005AU03','A185900TBP06','A1852005AU07','A185502NAH08','A1853015CA08','A1853015CA05','A185M005CA01','A185W00MCC07','A185W00NAK06','A185W00NAK04','A185W00MCC04','A184V018AK08','A185900JBH06','A185W00MCC02','A185W00PCA03','A185W00PCA08','A185N004AQ01','A185N004AQ03','A185800HAN06','A185W00LBG03','A185V018AR05','A185X007BE03','A185V026CB04','A185800HAN07','A1853003BC02','A185V015BH07','A185V031CA04','A185V02BCF07','A1851026AM08','A185V016CE01','A1856010AM01','A185W00LBJ07','A1856010AM05','A185W00LBJ03','A184L01FCC07','A184V01ACG06','A185W00LBJ08','A185W00LBJ04','A184L01FCC02','A185400SBT06','A184V01ACG08','A185W00HAH01','A185W012AC02','A185W00HAH08','A185W012AB07','A185W00KBW01','A185T024BL07','A185W00HAH04','A185W012AB08','A185700HCF02','A185V015BV06','A185V015BV01','A185V015BV08','A185601RBN06','A185800SAX04','A185800SAX02','A185400YBR07','A185T024AT05','A185601RBN03','A185V02CBB05','A185N00LBP01','A185700VAG07','A185700VAG03','A185K00CCF05','A185800KBS08','A185800KBS04','A185T024BU02','A185K00CCF04','A185L00ABK05','A185L00ABK04','A185700LAB07','A185700LAB04','A185700LAB01','A185L00FCA07','A185T024AH06','A185L00FCA01','A185T024AH03','A185E00VAE02','A185D00CBV07','A185800KBE02','A185R00XAT06','A185L00BBG03','A185L00BBG04','A185L007AU06','A1857010BJ07','A185K00XAL08','A185502ACA04','A185H02BBD01','A185H02BBD08','A185H02BBD06','A185800NCD04','A185T023AW05','A185T023AW08','A185L00PCK05','A185L00FCA02','A1856020AC08','A185T024BN06','A185L00FBM03','A185T024BN03','A185V02ACJ02','A1853002AB01','A185201WBD07','A185K00CBT02','A185M00EAA06','A185402UAX01','A185K00PAM06','A185T024BA06','A185500UCJ02','A185701EAY07','A185F00KBB07','A185701EAY03','A185400NBS07','A185500UCJ07','A185F00KBB06','A185502ABT05','A185K00PBA05','A185K00PBA03','A185T022BQ08','A185T022BQ01','A185K00PBA02','A185601XAB07','A185M00ABE03','A185S00YBU08','A185S00YBU01','A1853026BT06','A184J00QBG02','A185C013AX03','A185C013AX01','A185C013AX06','A185C013BR05','A185402TAM03','A1856003CC06','A185L009BF03','A185D00CAB07','A185F00GBF05','A185F00GBF01','A185701CCD08','A185K002BV07','A185L00ACH04','A185403EAP02','A185701CCD01','A185K002BV04','A185C00RCH08','A185800HCA07','A185J00QAQ03','A185W00LBT07','A185800HCA04','A185800HCA02','A185W00LBT04','A185M00KAN03','A185L00ACG04','A185200FCJ03','A185402BCK05','A185S00VBH07','A1853003BA01','A185S012AG01','A185S00VBH04','A185W014AJ01','A185W004AA06','A185V032BS07','A185V032BS03','A185V032BS02','A184T01QCJ08','A184T01QCJ07','A184T01QCJ01','A184T01QCJ02','A185Q00MBG01','A185S016AV03','A185S01CAK06','A185S01CAK01','A185S016AV05','A1852023BY02','A1852023BY05','A185K00VAT03','A185K00VAT01','A185J00QAN03','A1857019BE08','A1853003BB01','A185400MBC01','A1857019BE06','A1857019BE03','A185402UBD08','A185402UBD04','A185400NBR05','A185500UCK08','A185500UCD02','A1854011BW06','A185402TCK06','A1853024BK03','A185402TCK04','A185402TCH04','A185403CBM07','A185402TCH02','A185K00UAJ01','A185L00ABD03','A185402TCK01','A185402TCC07','A1856003BT04','A185601NAU03','A185K004AJ03','A185502AAC05','A185800LCJ07','A185P01BCF03','A185800LCJ03','A185800FAA05','A185800LCJ04','A185800FAA08','A185N00LBS05','A185800FCD03','A185800FCD01','A185400VBG08','A185P019CH02','A185U00WCC06','A185400VBG03','A185W00GBD08','A185Q00DBC05','A185900JBF01','A185V018BB02','A185900JBF06','A185P01GAV07','A185800HBG07','A185F00BBV02','A185P01GAV05','A185N00GAY01','A185V017CD02','A185P00TBK07','A185N00GAY02','A185P00TBK06','A185502JBH01','A1857013CK01','A185M00EAT06','A185W013BD05','A185900WBJ04','A185900WBJ03','A185U014BJ04','A1856029BE07','A185M00EAT02','A185900WBJ06','A185500WBE06','A185U014BJ02','A185U00XAH02','A185800FCH06','A185T023AK05','A1856029BE08','A185W013BD01','A1856029BE05','A185L00PAD04','A185W00GBD04','A185701BAY06','A185502AAP01','A185701BAY05','A185P00LBK03','A185C013BU02','A185700NAT02','A185700NAT05','A185C00QAL03','A185C00QAL06','A185701BAY02','A185800PCK07','A185S01CBK06','A1857018CG08','A185L00MAV01','A185L00HBG06','A185500WBE07','A185700LAS07','A185S019CG07','A184V029CB03','A185T026BJ07','A185T021AT04','A185T026BJ03','A184V029CB02','A185W013AD08','A185T026BJ01','A185C01QBW01','A185K00UAQ01','A185M00EAF06','A185W013BL03','A185R010BD07','A185W013BL08','A185700LAU04','A185400NCF08','A1851013AD04','A1852023CK06','A1851013AD01','A185601XAH04','A185700EBL04','A185601XAH01','A185701EBW04','A185800XAQ08','A185L00ABM07','A185800FBW08','A185L00ABM03','A185L00ABM08','A185800FBW02','A185L00ACE06','A185L00ABM02','A185800NAH07','A185M00KAP06','A185W00FCE08','A185502LAU08','A185L00EAU01','A185U00MAF07','A185U00MAF01','A185601BAX03','A184M01SBB02','A1854033BJ03','A185701AAX05','A185701AAX08','A185501EAB04','A185J00KAR06','A184T01YBM03','A1852008AA02','A185402UAJ05','A185J00MBB07','A185K004AP05','A1855022AP01','A185J00MBB06','A185K004AP01','A1857010BP03','A185V031AL08','A185400SAK07','A185V031AL02','A184M01PCH06','A184M01PCC05','A184M01PBS04','A184M01PCC02','A1857011BK08','A185S015BE04','A185200FAW02','A184M01PCH02','A1853014AD08','A185300AAX03','A185502LAR07','A185800WAX04','A185M00KBD02','A185800WAX02','A185601HAB05','A185W00FCG03','A185601HAB06','A185700YAT07','A185M00DAE07','A185800WAX01','A185W00FCD08','A185W00FCD06','A1857011AW05','A185M00JCE03','A185U025CA01','A185M00JCE02','A1857016AV01','A1853005AK05','A185V02CBK06','A185W00GAW02','A185K00VAY06','A185U014AT01','A185H00SBY06','A1853005AK04','A185401WAW01','A185N00MAW05','A185N00MAW07','A1854033AS06','A185502ABS05','A185402UAJ03','A1854038BT05','A1854038BT03','A185N00GAP02','A185S014CC03','A185N00MBD06','A185T02GBR03','A185W00KAR03','A185400SAY07','A1856019CD04','A185400SAY02','A185400SAY03','A184N01EAV03','A1857015BY03','A185700EBU07','A185K00GBH07','A185800UBK05','A185M006AM08','A185M006AM06','A185E00QBJ04','A185V01AAX07','A185400VAW03','A185800PBC07','A185800UBK01','A185800PBC02','A185800UBK04','A185800PBC08','A185800PBC03','A185V01AAX01','A185A00SAR01','A185V01AAX06','A185A00SAR08','A185N00MBP08','A185A00SAR04','A185403EAC03','A185403EAC02','A185W00GBE07','A184T01VBK04','A185W00GBE05','A185N00MAW02','A185U016AG01','A185L00LBV08','A185L00LBV07','A184T01VBK03','A185L00LBV03','A185S015BA07','A1854039AY04','A185M00CCA06','A185M00ACC07','A185400LAM03','A185V00MAN01','A185400LAM06','A185601XCJ08','A185403EAG05','A185403EAG01','A185601XCJ07','A185202JAH08','A185601XCJ04','A185400PAY01','A185701EBQ03','A185K00GAR02','A185N00DBY06','A1857010BD01','A1857010BD04','A1856005AR05','A1854029AA03','A185M008AT06','A185M008AT01','A185M004AB01','A185K00DAV03','A185F00FCB06','A1854010AX08','A1852008AA01','A185403CAM08','A184T01YBM07','A1855021AT04','A185Q00FAK08','A1853001BA08','A185K00BAM02','A185M00ABY05','A185M00ABY04','A185403EBU07','A185500SBP05','A185403EBU03','A185500SBP03','A185H00NBG03','A1853014AD05','A1853014AD07','A1853014AD01','A185501CBR05','A185900LBJ06','A185U011AU05','A185601YCE08','A185U011AU07','A185U011AU03','A185601YCE04','A185601YCE07','A185T023AL01','A1856005BC07','A1856005BC06','A185601GAN06','A1856005BC01','A185601GAN08','A185601GAN01','A185V02CBU02','A185L00AAQ04','A1854039AB08','A185600SAC03','A184V00DBC07','A184V018AR08','A185M007AW08','A184W027BN03','A185M008AH03','A185U015AV08','A185502LAW03','A185800PBK07','A185502LAW02','A185700GBM02','A185501EAB03','A185T009CD05','A185700GBM05','A185T009CD02','A1853002AP05','A185800PBK04','A185403CAC01','A1853002AP01','A185202HAW03','A185202HAW05','A185800SBD07','A185W00MAB05','A185V02CAS07','A185W00MAB04','A185J00SCA06','A185800SBD02','A185J00SCA01','A185402TBA02','A185J00SCA04','A185Q00PAU06','A185S010CH04','A185800WBB05','A185V032AF05','A185V032AF01','A185S012BJ02','A185G01GCE01','A185G004CB02','A184L01FCA01','A185K00PBV07','A185K00PBV08','A185200FBX05','A185200FAU06','A185200FBX03','A185800NAK07','A185700HAU08','A185W017BA02','A185700HAU02','A185400WBS04','A185V02BAN05','A185L00NBG02','A1853015BG08','A185S00VAV01','A1853015BG05','A1853015BG04','A185D00ECD02','A185C00RCB06','A185800UAV04','A1856003AF07','A1853001BE01','A1856003AF06','A185W00KAM04','A185900WAT06','A185402UAG01','A185700BAS08','A185L00DBF08','A185701BCK08','A185W016BL06','A185W00KBF06','A185500UBV01','A185500UBV04','A185W016BL07','A185800WAN08','A185W00KBF01','A185502NBD03','A185200BAE02','A1852023CC02','A185C01KBQ02','A185502NBD05','A184V013CD07','A185T021AL08','A185T021AL02','A185V01BCD01','A185800UAV01','A185C00RCB04','A185C00RCB01','A185C013CG03','A185601HBB01','A185T027BQ07','A185501CCB03','A185C013AV07','A185C013CH04','A185S01BAD03','A1855022CD03','A185M00EAM04','A185800WAN06','A185400PAG02','A185601HAD02','A1852023CC05','A185S010BT08','A185601HAD06','A185S010BT04','A185403JAN05','A185501EAL06','A184T02CBY05','A185501ECJ07','A185501ECJ08','A184V019CB04','A185T02CCB05','A185T02CCB08','A184T01LBQ03','A185500WAK08','A185500WAK01','A185W005CB08','A185U022AT06','A184V02FAS01','A184T01LAM04','A185U00MAU07','A185U00MAU06','A185S018CF06','A185F006AM05','A185401WBS04','A185H00LCE05','A185P01EBA07','A185200FCD01','A185T021AN02','A185S014CB08','A185G00KAY05','A185S014CB02','A185400MCB07','A185G003AC03')";
        String hql7=hql.toString()+" and materialname in('A185601CCG03','A185400MCB05','A185H00MBL08','A184T01LAM02','A185L00ABA05','A185L00ABA01','A185C00QAH05','A185V02AAF05','A185402UBR01','A1852038BE01','A185W005BU06','A185G00QAB04','A185G00QAB05','A185W005CG03','A185800WAU07','A184N01BBA08','A185800WAU05','A185N006CC07','A185H00SBU03','A185M005AA02','A1853017AG08','A185W00HAP03','A184W00JAS08','A185200FBD04','A185W00HAP05','A185Q00PCB02','A185K00SBR07','A185V02BAX03','A184V00XBP03','A185800HBQ03','A185K004AE03','A184T01PAR06','A185W00KCK05','A185W00KCK02','A1854014BH06','A1854014BH03','A185H00LCE04','A1853026BK02','A1854010BP04','A1854010BP06','A185500SBY03','A185700YBA07','A185K001BL03','A1856004AN03','A185C013CD05','A185C013CD01','A185C013CD04','A1851013BB07','A1854039CK06','A185U014BD07','A185U014BD05','A185T02CBC08','A185400NAT06','A185400NAT08','A185U014BD04','A185601NCD03','A1854033CE05','A185700YBA01','A185400UAK06','A185U015AX07','A185R01BBC05','A185U015AX06','A185401WAR02','A185U015AY07','A185R018AD01','A184H01GAD07','A185R018AD02','A185800NBG06','A185U015AY08','A185H00LBR08','A185500UBQ08','A185U015AY03','A185501CCH08','A185500UBQ02','A185500UBQ07','A1856010AH04','A185P01EAS05','A185600SBR07','A1854039CA01','A185600SBR01','A1854039AC01','A1854039AC04','A1854039CA03','A1852023CH04','A1853003BU04','A1853003BU06','A1852023CH01','A185U015AY05','A185501CCH02','A1856010BE05','A185T009AQ08','A185U015AU04','A185L00HBG07','A185L00FAL08','A185H003AK03','A185502BBT05','A1854033CE04','A1854033CE01','A185400NAT02','A1854010BJ05','A185200KBL02','A185S012BP08','A1854010BJ02','A185402BBG02','A185M00KAE07','A1854038AR03','A185402BBG05','A185403EBA01','A1854034BJ08','A185M00KAE01','A1857019AX01','A185403CCE07','A184W00JAS06','A184W00JAS03','A185500WAQ04','A185500WAQ08','A184W00JAS02','A185500WAQ06','A185V00MCC08','A185S012BJ04','A185200GAX03','A185401WBE01','A185W004BD07','A185W00NAD06','A185502NAF02','A185W00NAD03','A185H00LCK02','A185K00XBG08','A185V02ABR07','A185W017CJ04','A185W005CK02','A184T01PAA06','A185A00RBY07','A184T01PAA02','A185A00RBY08','A184T01PAA04','A185V02ABR04','A185S01CBJ08','A185U011AS05','A185400PCA01','A185403CBU06','A185501DBS05','A185501DBS07','A185C00RCG01','A185600SAA05','A184500VAL01','A185H00NBF06','A185500SCK04','A185D00CCA04','A185D00CCA07','A185K00SCJ05','A185W00GAL06','A185K00SCJ02','A185700HAA07','A1857019AT04','A184G00XBM08','A185L00FAQ02','A185T02FAA04','A184T01LBP08','A185W013BX06','A184C017AL04','A184C017AL03','A185W013BX02','A185800MAN04','A185G004CA04','A1855010BF04','A185800SBF03','A185201TAS07','A185W00JAX05','A185501DBS04','A185400QAR08','A185501DBS01','A185S01AAV01','A185400QAR06','A185400QAR04','A184T02BAV08','A1852025AD03','A184T02BAV06','A185C013BS07','A185K00ABX04','A185502KBM05','A1852007AA04','A185S012BS01','A185700LAF02','A185200BAE05','A184M01PBW05','A185T02FBW03','A185200BAE08','A185501CCF03','A185L00KAK08','A184H01GAH03','A184H01GAH01','A185601HBK05','A185D008BX01','A185D008BX02','A185W00GAJ07','A185P01BAP03','A185W00GAJ04','A185V02CBL06','A1856010AL03','A185A00LBK06','A185500SAQ03','A1856004AV02','A185C013BS05','A185C013BS04','A185500SAQ01','A185501EBP01','A185S01AAQ04','A185N00AAA08','A184G00XCD08','A185N00AAA01','A185P01HBT05','A185S01BCK05','A185S01BCK04','A185V02CAY03','A184M01PAN08','A185R016BE01','A184M01PAN03','A185701CAW06','A185S017BV07','A1852023CC07','A185W012AS02','A185W00GBT01','A185A00LBK04','A185B00GAV04','A185K00RBV05','A1856028AA03','A185K00RBV01','A185V014AJ07','A185700HAU01','A185K00RBV04','A185W017BA07','A185P00TBR05','A184T02GCF03','A185J00QAU06','A185T02BBJ08','A185601GAH04','A185T02BBJ05','A185J00QAU01','A185601GAH01','A185500WAD02','A185700GCC08','A185700GCC03','A185V033CE08','A185V033CE04','A185V02AAH02','A1854039BS05','A185V02AAH08','A185T021BU08','A185N006AP07','A185T021BU03','A184N01BBH06','A185V017BY01','A184N01BBH04','A1857019AD03','A1857019AD04','A185701AAV03','A185402TCE05','A185P01GAP01','A185701AAV04','A185400WAA03','A185300ABB01','A185L00BAT05','A185403JBK08','A185N00MBT06','A185L00BBF07','A185N00MBN07','A185P00LBE08','A185S010CH05','A185900NCD02','A185502BAR06','A185W004CG01','A184C017AD05','A185W004CG05','A185U00LAT06','A185H00NAW05','A1854039BU04','A185C013BU08','A185T026BB03','A1853003AQ05','A185Q00LAR06','A185W00MBV06','A185X00BBS03','A184M01PBL01','A185502FCK06','A1851013AP05','A185W016CA06','A185X00BBS01','A185502FCK05','A185402TBN05','A1851013AP08','A185502FCK01','A185W004AW04','A185U022AJ04','A184U00UBJ02','A185A00RBL08','A185502MBU08','A185502MBU06','A185Q00WAC03','A185Q00WAC05','A185W016CA02','A1852005AU04','A185900TBP04','A185502NAH06','A1853015CA07','A1853015CA02','A184V018AK03','A185R015CA03','A185N004AQ05','A185N004AQ06','A185V02ACJ05','A185X007BE05','A185800HAN08','A185U024AD08','A185V026CB08','A185U024AD03','A185V026CB05','A185U024AD05','A185V031CA06','A185V031CA03','A185800HAN03','A1851026AM05','A1856010AM08','A1856010AM04','A184V01ACG04','A185R016BQ01','A185400SBT05','A185700HCF08','A185T024BL05','A185W012AB01','A185700HCF07','A185800SAX01','A185W012AB02','A185601AAT01','A185V02CBB07','A185400YBR02','A185601RBD02','A1851026AF08','A185700LAB05','A184V02FCK03','A185N00CCJ06','A185L00FCA06','A185800KBE08','A185800KBB05','A185D00CBV08','A185L00BBG05','A185800KBE06','A185800KBE05','A185D00CBV02','A185L00BBG01','A185R00XAT04','A1852027AS04','A185T024AJ01','A1852027AS05','A184W022AU02','A185K00CCG08','A185K00XAL06','A185K00XAL05','A185700XAA05','A185502ACA07','A185K002AX07','A185900WCD02','A185900WCD04','A185800NCD07','A185K002AX06','A185T023AW03','A185700WAE06','A185L00PCK03','A185700WAE07','A185S019BQ05','A185K00XAL01','A1856020AC05','A185700WAE01','A185M00BCD07','A1853002AB05','A185M00BCD05','A185K00CBT04','A185S010BW01','A185M00EAA01','A185M00EAA03','A184V015AG04','A185M00EAA04','A185F00KBB05','A185500QBG03','A185L00MBF04','A185F00KBB01','A185L00MBF02','A185F00KBB08','A185M006AN01','A185400PBA08','A185502ABT03','A185601XAB04','A185R016AE01','A185402TAB01','A185601XAB03','A185L00MAB05','A185601XAB01','A1853026BT05','A185C013AX07','A1854039BY01','A185L00MAB04','A184J00QBG04','A185C013AX04','A185C013AX08','A185L00BCH05','A185L00BCH01','A185K002AW02','A185402TAM06','A185H00UAF05','A185H00UAF07','A185C013BR04','A1853005CK03','A185L00PAA01','A1856003CC02','A185L00PAA03','A185701CCD06','A185K002BV05','A1857012AJ06','A185700YAS03','A185J00QAQ07','A185J00QAQ06','A1857012AJ05','A1857018BX07','A185900XAX04','A185R010BD08','A185R010BD06','A185T02ACE05','A1852023CK01','A185200FCJ06','A185200FCJ01','A185200FCJ05','A185S012AG07','A185S012AG04','A1852023BY06','A185502FBS05','A185502FBS08','A185K00HBN04','A185W004AA03','A185W004AA02','A185502FBS03','A185V032BS06','A185502FBS06','A185502AAL01','A185502AAL04','A185M00BBR08','A1853015AU07','A185S01CAK08','A185502ABA08','A1852023CA06','A1853003BB08','A185J00QAN06','A1853025AE03','A1852023CA02','A185J00QAN04','A185400MBC06','A1857019BE04','A185U015BM08','A1853008AA07','A185701CAB02','A185402UBD02','A1853008AA01','A1853002AX03','A185200DAM02','A185701CAB05','A185Q00QAU02','A1854033BL07','A1854011BW03','A1854033BL04','A185L00ABD08','A1853024BK07','A1854033BL08','A184V02VBX08','A184V02VBX02','A184V02VBX07','A185403CBM08','A1853003CB05','A1853003CB01','A1856003BT06','A1856003BT02','A185402TCC03','A184T020AC05','A185601NAU02','A185P01BCF01','A185P01BCF04','A185N006AP02','A185800FAA07','A185P017AD03','A185P01BCF05','A185N009AQ04','A185N00LBS06','A185400VBG07','A185500YAK07','A185M00MAQ07','A185T029AT08','A185800LCG01','A185J00NAY01','A185800LCG08','A185Q00DBC01','A185M00MAQ06','A185T029AT05','A185900JBF07','A185V017CD06','A185700YAV07','A185P01GAV08','A185N00GAY05','A185800HBG01','A185700YAV01','A185P00TBK08','A1857013CK05','A185502BCK06','A185502JBH05','A185W013BD06','A185900WBJ08','A185M00EAT01','A185502JBH02','A185U00XAH01','A185U00XAH03','A185W013BD08','A1856029BE02','A185502AAP05','A185800PAG04','A185700NAT03','A185C00QAL07','A185701BAY07','A185S01CBK03','A185Q00QAV01','A1857018CG05','A185S00XCG05','A185502JAL01','A185500WBE02','A185T021AT07','A185S019CG03','A1856005BF07','A185T021AT08','A185S019CG04','A185T021AT02','A185M00EAF03','A185T021AT01','A184V029CB04','A185U00MBD04','A185400NCF03','A185P01HAQ08','A185C01QBW05','A1851013AD05','A1851013AD03','A185K00XAB06','A185900XAX08','A185L00ACG05','A185701EAB03','A185601XAH07','A1853001CG03','A185800XAQ03','A185800XAQ05','A185U022AF02','A185800XAM08','A185800XAQ01','A1853024AT06','A1853024AT08','A185800FBW04','A185800FBW07','A185L00ACE05','A185T021AU06','A185W00FCG05','A185T021AU03','A185M00KAP02','A185M00KBD08','A185502LAU07','A185601BAX06','A185L00AAQ01','A185U00MAF05','A1853002AF08','A185701AAX02','A1854033BJ04','A185701AAX04','A185L00EBD06','A185L00EBD08','A1854033BJ08','A185U013AW02','A185M005AX06','A185300AAN06','A184T01YBM08','A1855022AP07','A185402UAJ06','A185P01CAK02','A185402UAJ04','A185400SAK03','A185Q00PAA02','A184M01PCH05','A1857018CA04','A1857018CA06','A1853003CH02','A185R00YCC04','A184M01PBS03','A185400NCD02','A185S015BE01','A185502LAR01','A185402TBX01','A185800FCC08','A185800WAX05','A183M00RBE04','A185601HAB04','A185M00DAE01','A185601HAB01','A185K00PAL08','A185M004AT05','A185M00DAE02','A185800HBM04','A185W00FCD05','A185800HBM01','A185M00JCE07','A185M009BU01','A185900TAL01','A185800HBM06','A185M00JCE08','A185900TAL06','A185M00JCE06','A185900TAL04','A185U025CA02','A185M004AR06','A1853005AK01','A185U023BJ06','A1853005AK08','A185N00MAW08','A185N00GAP03','A1854038BT06','A185N00MBD08','A185700NAM04','A185N00MBD05','A185W00KAR07','A185W00KAR05','A1856019CD06','A184T02EAT05','A185400SAY06','A185500SBG05','A1853017BT08','A1853017BT03','A185202VCJ07','A184U00UAQ04','A185K00GBH03','A185M006AM03','A185400VAW01','A185800PBC04','A185M006AM04','A185M006AM02','A185N00MBP05','A185403EAC08','A185K00GAR07','A185W00GBE06','A185701ABQ08','A185H00SBY02','A185L00RAA06','A185U016AG02','A185R00WCC06','A185S015BA08','A185R00WCC02','A185L00LBV01','A185400LAM07','A1857015BY01','A185M00ACC08','A185M00ACC02','A185L00DBB03','A185202JAH07','A185700GAX07','A185403EAG03','A185700GAX08','A185202JAH01','A1854033AQ04','A185700GAX03','A185800HBT03','A185800HBT02','A185701EBQ05','A185701EBQ08','A185M004AB07','A185S015BA03','A1854029AA05','A185M004AB03','A185F00FCB05','A1852008AA06','A1854033AL05','A185U013AW06','A1852008AA04','A185403CAM06','A185K00SAA02','A185K00DAV01','A1855021AT07','A1853001BA05','A185Q00FAK05','A185M00ABY01','A1855022BH07','A1855022BH03','A185500SBP02','A1855022BH08','A185K00PAY02','A185U016BE03','A185300AAX04','A185U016BE07','A185501CBR02','A185T029CE02','A185U016BE01','A185900JAY01','A185U011AU01','A185701EAB07','A185900JAY04','A185G004AG03','A185900TAN07','A185V02CBU01','A185V02CBU05','A185V02CBU06','A185L00AAL01','A1854039AB02','A185900TAN06','A185600SAC07','A184V00DBC06','A184V00DBC04','A1855022BV08','A185M008AH08','A185502LAW06','A185502LAW08','A185B00GBH04','A185B00GBH03','A185J00TBU03','A185W00PCH05','A185J00TBU06','A185501EAB05','A185700GBM01','A185501EAB01','A185T009CD07','A185601RCG05','A185T009CD01','A185601RCG07','A1854039CA04','A185403CAC04','A185U016BC02','A185M00DCJ02','A185W00MAB02','A185202HAW04','A185800SBD08','A185J00SCA07','A185V02CAS05','A184U00YBA02','A185800WBB06','A185402TBA07','A185W00MBV05','A185800WBB01','A185V02CAS02','A184U00YBA05','A185W00QCE08','A1853003CG02','A185V032AF08','A185G01GCE08','A185G004CB05','A185G004CB06','A185200FBX07','A185M005BF02','A185K00UBN07','A185K00PBV02','A184M01PAF01','A185200FAU05','A185700YAD05','A185800NAK06','A185H00MBP05','A185C00QAH07','A185H00MBP02','A1853015BG02','A185V01BCD05','A185N00JAQ02','A1853001BQ08','A1853001BQ06','A185900WAT01','A185L00DBF07','A1853001BQ04','A185700BAS04','A184T02JBP02','A185403CAP05','A185500UBV05','A185402UAG03','A1854029CJ06','A185K00TAG01','A185W00KBF04','A185M00MAS07','A185W016BL08','A185M00MAS08','A184M01PAN05','A185L00ABT03','A185502NBD08','A185400WAN06','A185T029CD03','A185T00ABN07','A185601XCD08','A185T00ABN04','A185601HBB03','A185C00RCB02','A185501CCB04','A185W00MAG06','A185W00MAG05','A185501CCB07','A185T027BQ05','A185T027BQ03','A185C013CH06','A185T027BQ01','A184V012BP05','A185M009BR05','A185C013AV05','A185M00MAS01','A185W00KBF03','A185800WAN07','A185800WAN05','A1855022CD04','A185601HAD05','A185601HAD01','A185601XCD04','A185403JAN08','A185R00XCC01','A185G00NBA08','A185S010BT07','A185300AAY07','A185S017AK01','A185G00NBA02','A185N00KBG07','A185T021AN04','A185501EAL05','A185M009BR08','A185502JAT08','A184T02CBY03','A1854039AF01','A185501EAL02','A185M009BR01','A185502JAT04','A185C013AV04','A184T02CBY02','A185Q00SBB02','A185502JAT03','A185T02CCB06','A1855022CD02','A185T02CCB01','A184T01LBQ01','A185K00XAK02','A185U022AV07','A185V00MBM06','A185U022AV02','A185U022AV04','A185V00MBM04','A185W005CB04','A184V02FAS07','A184T01LAM08','A185S017CF07','A1854039AJ05','A185F006AM04','A185401WBS06','A185800HCG08','A185200FCD07','A185800HCG03','A185300AAY03','A185502JAF04','A185N00KBG03','A185701FAH05','A185N00KBG06','A185S014CB03','A185200FCD02','A185S014CB01','A185F006AR08','A185S014CB06','A185H00MBL04','A185S017BV06','A185K00SBA06','A185H00MBL06','A1852038BE06','A1853024BT07','A185800LCG07','A185V02AAF07','A185700AAJ01','A185T029AT03','A185502JAC03','A185W005CG04','A185G00QAB03','A185G00QAB01','A185D00LAU06','A185W005CG05','A185G00SAQ03','A185N006CC01','A185N006CC05','A185L00FAK03','A185L00EAU02','A185V019AW01','A185P01DBR08','A185P01DBR07','A185W00HAS01','A185P01DBR06','A185W00HCC08','A185W014AA03','A185K00SBR05','A185K00SBR08','A185W014AA04','A185K00SBR03','A185800HBQ02','A185601GAC07','A185K00SBR01','A185K00SBR02','A185800HBQ06','A185K004AE08','A185H00LCK07','A185K004AE01','A185V02BAX04','A185V02BAX07','A185800HBQ01','A1857018CJ08','A1857019CK07','A185W00KCK03','A185401WBS02','A185H00LCE06','A1853026BK06','A185H00PBQ08','A185H00MBC04','A185H00MBC02','A185403CAX05','A185S01ABB08','A185500SBY08','A185403CAX08','A185403CAX01','A1854039CK07','A1851013BB05','A1851013BB04','A1854039CK08','A1854039CK02','A185X008AE03','A1856010AA06','A185V01BBD03','A185403CAK08','A185R01BBC03','A185L00JBV07','A185400UAK05','A185R01BBC02','A185R018AD06','A185401WAR01','A185U015AX02','A184H01GAD05','A185800NBG04','A1855010CJ05','A1856010AH01','A185M00HAB07','A185S018CF02','A185P01EAS08','A184V02ECE07','A185500UBQ01','A185400UAK02','A1854039AC03','A185600SBR04','A1852023CH03','A1853003BU02','A185V017AY04','A185V017AY08','A184V02ECE05','A1856010BE01','A1857019AS05','A185800UBH07','A184V02ECE01','A185502KAF03','A185502KAF05','A185J00TBG01','A185800UBH04','A185T009AQ06','A1857019AS08','A185T009AQ02','A185L00FAQ06','A185L00FAQ03','A185T021AP03','A1857019AT03','A185L00FAQ01','A185V017AY03','A185V017AY02','A185200FBP06','A184T01NAV07','A1852027AD06','A185S00XCG08','A185S01CAD05','A185L00FAL07','A185S01CAD03','A185L00FAL06','A185V018BA02','A185T02CBC04','A185S012BP07','A1854038AR07','A1854010BJ01','A185V015AB02','A185S016AY03','A185403EBA05','A185M00KAE05','A185500SAT03','A185403CBU08','A1857019AX04','A185M00KAE04','A185403EBA02','A1852023CE04','A185W00FBE04','A185200FBD03','A1853003CG04','A185500WAQ03','A185Q00MAT08','A185401WBE05','A185401WBE03')";
        String hql8=hql.toString()+" and materialname in('A185W014AC06','A185W004BD06','A185T02EAK02','A185K00XBG06','A185W004BA01','A185W017CJ01','A185W017CJ02','A184T01PAA05','A185V02ABR03','A184T01PAA03','A185A00RBY04','A185A00RBY01','A185C013BY08','A185S017AW03','A185S017AW01','A185403CBU03','A185K00HCF02','A185403CCE08','A185400PCA08','A185U011AS03','A185C00RCG04','A1857012AA05','A185U015BS01','A185W00GAL05','A185W00GAL08','A185W00GAL04','A185701FCH08','A185700HAA06','A1857019AT01','A185T02FAA07','A185T021AP01','A185800MAF03','A185T02FAA06','A185T02FAA01','A185P00TAG01','A185S01AAR06','A185T023BH01','A184C017AL02','A185401WBQ05','A1855010BF07','A185800MAN02','A185501CCH07','A185G004CA02','A1855010BF08','A185401WBQ02','A185700LBG05','A185800SBR02','A185800SBF01','A1852027AR05','A185W00JAX02','A185400QAR07','A185500SCK02','A185L00FBF03','A1852025AD08','A185L00FBF01','A185C01QCD06','A1852007AA02','A185C01KBV08','A185T026CE05','A185C01KBV02','A185C01KBV01','A184M01PBW08','A185V02CAY05','A185D008BX05','A185W00GAJ01','A185800MAD07','A185K00TAL08','A185C013BS03','A185C013BS08','A185502KBM08','A185W00KAM05','A185K00TAL02','A185N00JCK01','A184M01PBW06','A185N00AAA05','A185N00AAA06','A185S01BCK06','A185S01BCK08','A185R016BE03','A185S017BV04','A1852023CC03','A185T029CD08','A185W012AS04','A185B00GAV06','A185700HCH04','A185K00RBV03','A184V02FAR07','A185P00TBR06','A185U016BC06','A185601GAH03','A185502JCG08','A184W027BN08','A185700GCC01','A185T02DBG08','A185V033CE07','A185T02DBG06','A185M008AH07','A185T02DBG02','A185T021BU05','A185V02AAH03','A185N007AU02','A185N009AQ05','A185M007AV06','A185502AAC04','A185501CBR03','A184N01BBH08','A184N01BBH07','A185200FAU02','A1857019AD07','A185M00ECA03','A185701AAV02','A185P01GAP03','A185701AAV07','A185400WAA04','A185700GCA01','A185700GCA06','A185L00BAT02','A184T02GCF08','A185L00BBF08','A185L00BBF04','A185N00MBT02','A185N00MBN01','A185N00MBN02','A185N00JBP08','A185Q00PBY02','A185W00KAR01','A185N00JBP02','A185K00SAS03','A185K00SAS06','A185502BAR03','A185701ABJ02','A185502BAR08','A185502BAR01','A185W00QCE03','A1853002AY06','A185U00LAT08','A185X007BR07','A184C017AD04')";


        List<SpcDcdata> list1=mesdao.list(SpcDcdata.class, hql1);
        List<SpcDcdata> list2=mesdao.list(SpcDcdata.class, hql2);
        List<SpcDcdata> list3=mesdao.list(SpcDcdata.class, hql3);
        List<SpcDcdata> list4=mesdao.list(SpcDcdata.class, hql4);
        List<SpcDcdata> list5=mesdao.list(SpcDcdata.class, hql5);
        List<SpcDcdata> list6=mesdao.list(SpcDcdata.class, hql6);
        List<SpcDcdata> list7=mesdao.list(SpcDcdata.class, hql7);

        if(!list2.isEmpty()) list2.forEach(e -> list1.add(e));
        if(!list3.isEmpty()) list3.forEach(e -> list1.add(e));
        if(!list4.isEmpty()) list4.forEach(e -> list1.add(e));
        if(!list5.isEmpty()) list5.forEach(e -> list1.add(e));
        if(!list6.isEmpty()) list6.forEach(e -> list1.add(e));
        if(!list7.isEmpty()) list7.forEach(e -> list1.add(e));

        return list1;
    }

    public List<SpcDcResultData> loadMDataList(EtlConfDModel etlConfD, long dcdataid) {
        List<SpcDcmeasuredataresult> spcDcmeasuredataresultList =new ArrayList<>();
        List<SpcDcResultData> spcDcResultDataList=new ArrayList<>();
        StringBuffer hql = new StringBuffer();
        hql.append("FROM SpcDcmeasuredataresult WHERE dcdataid =").append(dcdataid)
        .append(" order by itemname, sitename");
        spcDcmeasuredataresultList =mesdao.list(SpcDcmeasuredataresult.class, hql.toString());
        spcDcmeasuredataresultList.forEach(e->{
            SpcDcResultData spcDcResultData=new SpcDcResultData();
            spcDcResultData.setDcdataid(e.getDcdataid());
            spcDcResultData.setSeq(e.getSeq());
            spcDcResultData.setSamplematerialname(ProcessUtil.processString(e.getSamplematerialname()));
            spcDcResultData.setItemname(ProcessUtil.processString(e.getItemname()));
            spcDcResultData.setSitename(ProcessUtil.processString(e.getSitename()));
            spcDcResultData.setSitetype(ProcessUtil.processString(e.getSitetype()));
            spcDcResultData.setAliasitemname(ProcessUtil.processString(e.getAliasitemname()));
            spcDcResultData.setDatatype(ProcessUtil.processString(e.getDatatype()));
            spcDcResultData.setResult(ProcessUtil.processString(e.getResult()));
            spcDcResultData.setEventname(ProcessUtil.processString(e.getEventname()));
            spcDcResultData.setTimekey(ProcessUtil.processString(e.getTimekey()));
            spcDcResultData.setEventtime(e.getEventtime());
            spcDcResultData.setEventuser(ProcessUtil.processString(e.getEventuser()));
            spcDcResultData.setEventcomment(ProcessUtil.processString(e.getEventcomment()));
            spcDcResultData.setUpdatetime(e.getUpdatetime());
            spcDcResultDataList.add(spcDcResultData);
        });
        return spcDcResultDataList;
    }

    public List<SpcDcResultData> loadPDataList(EtlConfDModel etlConfD, long dcdataid) {
        List<SpcDcprocessdataresult> spcDcprocessdataresult =new ArrayList<>();
        List<SpcDcResultData> spcDcResultDataList=new ArrayList<>();
        StringBuffer hql = new StringBuffer();
        hql.append("FROM SpcDcprocessdataresult WHERE dcdataid =").append(dcdataid)
                .append(" order by itemname, sitename");
        spcDcprocessdataresult =mesdao.list(SpcDcprocessdataresult.class, hql.toString());
        spcDcprocessdataresult.forEach(e->{
            SpcDcResultData spcDcResultData=new SpcDcResultData();
            spcDcResultData.setDcdataid(e.getDcdataid());
            spcDcResultData.setSeq(e.getSeq());
            spcDcResultData.setSamplematerialname(ProcessUtil.processString(e.getSamplematerialname()));
            spcDcResultData.setItemname(ProcessUtil.processString(e.getItemname()));
            spcDcResultData.setSitename(ProcessUtil.processString(e.getSitename()));
            spcDcResultData.setSitetype(ProcessUtil.processString(e.getSitetype()));
            spcDcResultData.setAliasitemname(ProcessUtil.processString(e.getAliasitemname()));
            spcDcResultData.setDatatype(ProcessUtil.processString(e.getDatatype()));
            spcDcResultData.setResult(ProcessUtil.processString(e.getResult()));
            spcDcResultData.setEventname(ProcessUtil.processString(e.getEventname()));
            spcDcResultData.setTimekey(ProcessUtil.processString(e.getTimekey()));
            spcDcResultData.setEventtime(e.getEventtime());
            spcDcResultData.setEventuser(ProcessUtil.processString(e.getEventuser()));
            spcDcResultData.setEventcomment(ProcessUtil.processString(e.getEventcomment()));
            spcDcResultData.setUpdatetime(e.getUpdatetime());
            spcDcResultDataList.add(spcDcResultData);
        });
        return spcDcResultDataList;
    }


    private String getOpeHql(String confOpe) {
        if (StringUtils.isEmpty(confOpe)) {
            return "";
        }

        StringBuffer hql = new StringBuffer();
        if ("*".contains(confOpe)) {
            //todo 允许模糊匹配
        } else {
            hql.append(" and opeId='").append(confOpe).append("' ");
        }

        return hql.toString();
    }


}
